help with a query to make it one query instead of two

[rondog]

I have two tables. We'll call them Table1 and Table2 for simplicity.

 

Table1 contains an id called 'field_id'. I query the DB and get an array of those IDs.

 

Now I use those IDs to query Table2

 

Basically something like

SELECT * FROM Table2 WHERE fid = '$the IDs from Table1'

 

My question is, is it possible to write this in one query? I know how to do it in two separate queries, but I would like to consolidate. Thanks.

[ChemicalBliss]

Not if your getting multiple different id's that you need to loop through. (You probably could but at the most advanced scale of mysql that i dont know much about).

 

If, for instance, your using the first table to get the all rows with that single id_no from another table, then you would use a JOIN clause.

 

check here for a simple tutorial i googled:

http://www.tizag.com/mysqlTutorial/mysqlleftjoin.php

 

Hope this helps,

-cb-

[rondog]

yea theyre all different ids...doing a loop is the only way I know how to do it too.