Access Query to show records that do NOT meet join criteria

  • Thread starter Thread starter BillG
  • Start date Start date
B

BillG

I would like to create a query that shows records that don't meet join
criteria.

One table has all records, the other has those I want to eliminate. What
kind of query do I use to show the remaining records only?
 
Unmatched query.
SELECT TableALL.*
FROM TableALL LEFT JOIN TableSOME ON TableALL.SomeField = TableSOME.SomeField
WHERE TableSOME.SomeField Is Null;

SomeField is a common field like employee number or product code.
 
Back
Top