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

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

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

Posted by: Guest on November-17-2021

Code answers related to "How to select rows with no matching entry in another table?"

Code answers related to "SQL"

Browse Popular Code Answers by Language

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

Code answers related to "How to select rows with no matching entry in another table?"

Code answers related to "SQL"

Browse Popular Code Answers by Language

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

Code answers related to "How to select rows with no matching entry in another table?"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us