Home » 2012 » April » 20

Archive for April 20, 2012

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