Union query

I have a query of the form

query1 union query2

Both queries have a common field f1.
My problem is to get only those records from query2 which have a corresponding record (same f1 value) in query1. In other words there should be no record in query2 that has x in f1 and there does not exist an x in query1. Is there a simple way or do I have to write a complex 'exists' condition in query2 ?

thx. Received on Tue Dec 12 2006 - 04:57:21 CST