Originally posted by: g8r
It will work, but you'd be better off using an inner join between the tables on the two fields.
Beware of duplicate records when INNER JOIN!
Try EXISTS instead
select t1.fld1, t1.fld2 from tbl1 as t1
where exists ( select * from tbl2 as t2 where t2.fld1 = t1.fld1 and t2.fld2 = t1.fld2)