Excluding Records of one Table from the Other Table

Problem Statement: There are two tables and we need to get all the records from Table1 that are not in Table2.

   Table1                           Table2
Emp_id	Salary			Emp_id	Name
1	10000			1	Tom
2	23000			2	Rock
4	40000			3	Thor
9	34000				

Excluding Records from Table1 that Exist in Table2

Solution: It can be done in two ways, using Left Join OR using Exists condition.

Using Left Join:

SELECT T1.EMP_ID 
        FROM 
            TABLE1 as T1 LEFT JOIN TABLE2 as T2 
                    ON T1.Emp_ID = T2.EMP_ID 
 WHERE T2.Name is Null

Using EXISTS Condition:

SELECT T1.EMP_ID 
           FROM Table1 as T1 
 WHERE NOT  EXISTS (SELECT Emp_id FROM Table2 as T2 Where T1.Emp_id = T2.Emp_id)

Result:

EMP_ID
9
4