Substraction of two queries

BeataG

Registered User.
Local time
Today, 09:32
Joined
Oct 24, 2008
Messages
21
Hello,

I'd like to ask you if it is possible to substract one query from the second query. Both queries have the same columns and they are put in the same order, so their composition is identical.
In the 1st query there is a list containg some names that may be also in 2nd query and other names that are only in the 1st query.
My goal is to select only those names that are in the 1st query, and at the same time are not in the 2nd query.

Is it possible to do?
If not with queries, maybe with tables?
Thank you in advance for any help.
 
You use an outerjoin with the field in the second query=null, but just use the unmatched query wizard.

brian
 
Thank you for your help.
Regards.
 

Users who are viewing this thread

Back
Top Bottom