Home » 2012 » April

Archive for April, 2012

Find missing record using query

April 20, 2012 - Posted in Access, MS SQL, SQL - Permalink

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