Outer join in sql server

Question

Hi Can anyone tell me about Outer join with an example ? Also explain types of Outer join in SQL server.

Arul Selvan · Answer

Outer join has 3 types 1.left outer join 2.right outer join 3.full outer join In normal join compare two table and display rows which match based on condition but left outer join display all values from left side table and display matched value only right side table see below example employee table department table see above tables both have depid left outer join select employee.empidemployee.empnamedepartment.depiddepartment.depname from employee left outer join department on employee.depid=department.depid; now see the left side all values are displayed and right side table which are not match it display NULL The right outer join opposite to left outer join The full join both side it display not matched value as NULL select employee.empidemployee.empnamedepartment.depiddepartment.depname from employee full outer join department on employee.depid=department.depid;