LEFT JOIN or LEFT OUTER JOIN in SQL Server

Long Answer
Views 387

Answer:

LEFT JOIN or LEFT OUTER JOIN
Now, let's say, I want all the rows from the Employees table, including JAMES and RUSSELL records. I want the output, as shown below.

Code: 

<span class="pln">
SELECT </span><span class="typ">Name</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Gender</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Salary</span><span class="pun">,</span><span class="pln"> </span><span class="typ">DepartmentName</span><span class="pln">
FROM tblEmployee
LEFT OUTER JOIN tblDepartment
ON tblEmployee</span><span class="pun">.</span><span class="typ">DepartmentId</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> tblDepartment</span><span class="pun">.</span><span class="typ">Id</span><span class="pln">
</span>

OR 

<span class="pln">
SELECT </span><span class="typ">Name</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Gender</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Salary</span><span class="pun">,</span><span class="pln"> </span><span class="typ">DepartmentName</span><span class="pln">
FROM tblEmployee
LEFT JOIN tblDepartment
ON tblEmployee</span><span class="pun">.</span><span class="typ">DepartmentId</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> tblDepartment</span><span class="pun">.</span><span class="typ">Id</span><span class="pln">
</span>

Note:

Related Articles:

This section is dedicated exclusively to Questions & Answers. For an in-depth exploration of SQL, click the links and dive deeper into this subject.

Go to Question List

Join Our telegram group to ask Questions

Click below button to join our groups.

Ask Question - CSE
Programming Language - PDF