Not In?

  • Thread starter Thread starter newperson
  • Start date Start date
N

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!!
 
newperson said:
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!
Click to expand...
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
 
Back
Top