Write The SQL Query to Find Record From Table Employee That Does Not Exist in Other Two Table Employee_Ah and Employee_BA
Query 1
Select * From Employee
Where ID Not IN (Select ID FRom Employee_Ah)
And ID Not IN (Select ID FRom Employee_Ba)
Query 2
Select * From Employee
Where ID Not IN (Select ID FRom Employee_Ah)
And ID Not IN (Select ID FRom Employee_Ba)
Query 2
Select E.ID, E.Name From Employee E
Left Outer Join Employee_Ah EA
ON E.ID = EA.ID
Left Outer Join Employee_Ba EB
ON E.ID = EB.ID
Where EA.ID IS Null
And EB.ID Is Null
Result
