SQL Server LEFT OUTER JOIN

SQL Server LEFT OUTER JOIN

SQL Server Left Outer Join displays all rows from Left table.

SYNATX:

SELECT * FROM 

[Table 1]

LEFT OUTER JOIN 

[Table 2]

ON CONDITION.

 For ex: Employee belongs to One Department.

If Table 1 is Department , then SQL Server Left outer join displays all rows from Department table.

select * from 

Dept

LEFT OUTER JOIN

Emp

on DEPT.DEPTNO=EMP.DEPTNO;