Before anyone asks, this isn't homework, its a potential aid to an unfortunately very real problem :D
I have a query which works fine that goes:
select stuff from table1 where id1 = 'string_id1' and id2 = 'string'
My problem is I have the values for string_id1 and string_id2 in another table i.e table2. So to be clear, table2 consists of 2 columns called string_id1 and string_id2.
I want the results of the query for each line in table2. What's the best way to do this?