FULL JOIN or FULL OUTER JOIN in SQL Server

Question

Accepted Answer

Figure:  

 Figure:  

FULL JOIN or FULL OUTER JOINI want all the rows from both the tables involved in the join. The query output should be, as shown below.

 Figure:  

Code: 


SELECT Name, Gender, Salary, DepartmentName
FROM tblEmployee
FULL OUTER JOIN tblDepartment
ON tblEmployee.DepartmentId = tblDepartment.Id



 OR 


SELECT Name, Gender, Salary, DepartmentName
FROM tblEmployee
FULL JOIN tblDepartment
ON tblEmployee.DepartmentId = tblDepartment.Id



Note:

FULL JOIN or FULL OUTER JOIN in SQL Server

Answer with Explanation

Code:

OR