Not In?

[newperson]

I am using SQL in Access 2003
I have a query, 'A'
I selected certain data from query 'A', to create query 'B'
I want to create a query 'C' that includes all data from 'A' not in 'B'
How do I do this? Maybe the answer is right in my face!

Thanks!!

 

[vanderghast]

Use the query wizard about finding unmatched records?

Vanderghast, Access MVP

 

[Bob Barrows]

I am using SQL in Access 2003
I have a query, 'A'
I selected certain data from query 'A', to create query 'B'
I want to create a query 'C' that includes all data from 'A' not in
'B' How do I do this? Maybe the answer is right in my face!

Use an outer join between the two queries.
Select A.*
FROM A left outer join B on A.keyfield=B.keyfield
WHERE B.keyfield IS NULL