Matching a row to multiple rows in another table.

Matching a row to multiple rows in another table.

am 01.04.2007 06:57:02 von sherzodr

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
table2.

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

Appreciate your time, folks. Thank you