The Query wizard includes an "unmatched query" that will do what you are asking for.
R RBear3 Apr 26, 2007 #1 The Query wizard includes an "unmatched query" that will do what you are asking for.
J john Apr 26, 2007 #2 I have two queries Q1 and Q2 which have a common ID field. I want to get the records of Q1 except those where the ID exists in Q2. Is there a way to do this? TIA
I have two queries Q1 and Q2 which have a common ID field. I want to get the records of Q1 except those where the ID exists in Q2. Is there a way to do this? TIA
S Sean Apr 27, 2007 #4 You can also use a sub query in the where statement. Were: Not in (select uniqueID from Q2). You will need to do a right join for your 2 tables, select all from Q1 and only those in Q2 that match.
You can also use a sub query in the where statement. Were: Not in (select uniqueID from Q2). You will need to do a right join for your 2 tables, select all from Q1 and only those in Q2 that match.
