Hi all,

I have an SQL query question which I hope you can help me with.

I have 2 tables
1) requests
2) Bids for requests

Table 2 contains an 'id' item which points to table 1 entry, as well as a user-id
which indicates which user posted up the bid for the particular request

I need to list all 'requests' which a specific user bid for. I know I can first
loop over the bid table choose only the ones which match the specific user, and for each entry list list the specific request.

Is there a way to select from table 1 based on table 2.

the SQL statement would be something in the lines of:
"Select * from [table1] WHERE exists entries in [table2] with user-id=x"

Thank in advance,
Dror