Dep_table depid subname empid ------- ------ ------------- 101 cs 4 102 ec 1 103 eee 5 104 mech 2 105 civil 4
SELECT Emp_table.empid, Emp_table.name FROM Emp_table LEFT JOIN dep_table ON dep_table.empid = Emp_table.empid WHERE dep_table.depid IS NULL
NOT EXISTS
LEFT JOIN
SELECT name FROM emp_table WHERE Not Exists ( SELECT 1 FROM dep_table WHERE dep_table.empid = emp_table.empid ) ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)