selecting one table and using info from that to get other info from another tabl

[andrew_biggart]

Hey there il try and keep this short but basically i am designing an online clothing auction site and i would like to get the all item id's from my bids table that = my user id, and once i get all of the results i then want to get all the item info which is in a different table usuing the returned item id's from the bids table. Do i need to use 2 sql statements or what do i need to do ???

 

hope this makes some sense and thanks in advance

[Barand]

A single query joining the two tables would be better