Home » Applications » Access » Find missing record using query

Find missing record using query

After running the query to update table records the record(s) is missing. Run this query to find the missing record.


SELECT Table1.column
FROM Table1
LEFT JOIN Table2 ON
Table1.column = Table2.Column
WHERE Table2.column is NULL;

* Replace Table1 and *2 with your table names