not in query

[Him]

I need a query to show records in table1 that are not in table2.
e.g.
table1.person_pk not found in table2.person_pk

 

[Rick B]

That is an unmatched query. The wizard will help you build one.