Please, i want to compare a column in table with 2 colomns in another table. Such dat if the values on the first column corresponds to the other then it will do something. I've tried SELECT * FROM tblToad frm d first table and then SELECT color FROM tblcolor, bt i don't know how to bring the both tables together to compare. Pls help needed
shelexelex 0 Light Poster
debasisdas 580 Posting Genius Featured Poster
I think you need to join both the tables.
It will be better if you post the structure of the underlying tables for better analysis.
AndreRet 526 Senior Poster
Debasisdas is correct, you will use an INNER JOIN statement providing that you have indexed your fields in your tables as primary...
As he did ask, show us the structure of all tables.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.