Access Query to show records that do NOT meet join criteria

[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?

 

[KARL DEWEY]

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.