[thelist] MYSQL MULTIPLE TABLES SELECT QUESTION

[Onyango, Felix]

Guys, I am somewhat a newbie is MySQL, what I have is several tables
containing products offered by different manufactures. All tables have
identical structures.

What I want to do is to construct a query that will search all the
tables for a particular column and return ALL (*) data if that column
matches.

Here is an example of what I am taking about

Table 1 = Dickies

Table 2 = Levi 

 

ALL Tables Structure: Gender,Name,P_ID,Color,G_ID,Qty

 

"  SELECT * FROM Dickies, levi WHERE Dickies.Gender='F' AND
Levi.Gender='F'   "

 

I been on Google and have read all sorts of documentation but yet to
find any information on how to construct this query - Maybe I am looking
for the wrong information. I did however find a lot of documentation
about using the JOIN statement,  - Could this be the answer? If yes, how
do I go about it.

 

Felix Onyango

Systems Admin