Delete from Employe where EmpID not in(select EmpID from Project with(nolock))
DELETE FROM Employe FROM Employe A LEFT OUTER JOIN Project B ON A.EmpID = B.EmpID WHERE B.EmpID IS NULL
JOIN
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)