How to select rows with no matching entry in another table?

The solution for this is noted below

How to select rows with no matching entry in another table?

Solution

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

Try other methods by searching on the site. That is if this doesn’t work