LEFT JOIN or LEFT OUTER JOIN in SQL Server

Question

Accepted Answer

Figure:  

 Figure:  

LEFT JOIN or LEFT OUTER JOINNow, let's say, I want all the rows from the Employees table, including JAMES and RUSSELL records. I want the output, as shown below.

 Figure:  

Code: 


SELECT Name, Gender, Salary, DepartmentName
FROM tblEmployee
LEFT OUTER JOIN tblDepartment
ON tblEmployee.DepartmentId = tblDepartment.Id




 OR  


SELECT Name, Gender, Salary, DepartmentName
FROM tblEmployee
LEFT JOIN tblDepartment
ON tblEmployee.DepartmentId = tblDepartment.Id



Note:

LEFT JOIN or LEFT OUTER JOIN in SQL Server

Answer with Explanation

Code:

OR