Home / Software / Tips and Tricks / How to find records from one table which don't exist in another table?

How to find records from one table which don't exist in another table?

Updated:  12/15/2015 06:12 AM
Author:  Shiju Mathews

Status:    Resolved.


This can be found by left or right join as per the requirement.

The LEFT JOIN keyword returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.