NOT COMMON RECORDS FROM TWO TABLE

 --NOT COMMON RECORDS FROM TWO TABLE

USE [SSIS]
SELECT REPLICATE('*',100) as 'INPUT_TABLE'
SELECT * FROM [dbo].[emp_2020]
SELECT * FROM [dbo].[emp_2021]

------1ST WAY OF SOLUTION-----

SELECT REPLICATE('*',100) as 'OUTPUT_TABLE'

SELECT * FROM [dbo].[emp_2020] E_20 WHERE E_20.emp_id NOT IN 
(
SELECT E_21.emp_id   FROM [dbo].[emp_2021] E_21 
)
UNION ALL
SELECT * FROM [dbo].[emp_2021] E_20 WHERE E_20.emp_id NOT IN 
(
SELECT E_20.emp_id   FROM [dbo].[emp_2020] E_20
)

----------2ND WAY OF SOLUTION---------------------

SELECT E_20.emp_id,E_21.emp_id FROM [dbo].[emp_2020] E_20
FULL JOIN  [dbo].[emp_2021] E_21 ON E_20.emp_id = E_21.emp_id
WHERE E_20.emp_id IS  NULL OR E_21.emp_id IS  NULL