In this video I have explained 4 solutions to solve a very common SQL scenarios to find records that exists in one table and not present in other table.

Categories & Patterns discussed in this video:
======================================================
/*
Solution 1
Category: JOINS
Pattern: LEFT with NULL
*/
======================================================
/*
Solution 2
Category: Miscellaneous
Pattern: SET Operators
*/
======================================================
/*
Solution 3
Category: WHERE
Pattern: NOT IN
*/
======================================================
/*
Solution 4
Category: WHERE
Pattern: NOT EXISTS
*/

Let me know if you need any help in learning SQL.