Question : How to select rows with no matching entry in another table?
Answered by : samy
SELECT Name, Gender,country, Salary, DeptName
FROM tbl_Employee
LEFT OUTER JOIN tbl_Department
ON tbl_Employee.DepartmentId = tbl_Department.DeptId
where tbl_Employee.DepartmentId is null Source : | Last Update : Wed, 24 Nov 21