LEFT OUTER JOIN Example

Left Outer Join Example :

Table 1:



Table 2:





Query and Result Set :-




For example if the left outside(Table1 : Empdetails) contains some extra records which are not  in Right side table(Table 2: Department). The result set will be below.

Table A: EmpDetails



Table 2: Department:


The Query and Result set :