Matching a row to multiple rows in another table.

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

If anyone can help me with this problem, I'll make you my hero of the
month (preferably April 2007). I'll even pin your name above my desk
for the whole month. Oh yes I can do that!

I need to match a record in table1 with multiple records in table2,
and return the record only if it matches all those select records on

I may need MAGIC UNIONS, MAGIC JOINS, or may be simple subqueries. I
am not sure.

Appreciate your time, folks. Thank you

Site Timeline