Join to get "exception" records

  • Thread starter Thread starter RBear3
  • Start date Start date
R

RBear3

The Query wizard includes an "unmatched query" that will do what you are
asking for.
 
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
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query is not working 1
Weird 2007 left join query 1
Making a Delete Qiuery from an unmatched Query 3
Joins in unmatched query 2
NOT IN (SQL) or Find Unmatched (+ other stuff) 21
composite key unmatched query 1
how to resolve a parameter conflict with unmatched records query? 7
Unmatched query question 3

Back
Top