I have an SQL query question which I hope you can help me with.
I have 2 tables
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,