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
Recommended Answers
Jump to PostI think you need to join both the tables.
It will be better if you post the structure of the underlying tables for better analysis.
All 2 Replies
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.