Rigth Outer Join Example

Right Outer Join Example:

Table 1 : EmpDetails


Table 2 Department





The Query and Result set:




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

Table 1 :Department:







Table 2 :EmpDetails:



The Query and Result set will be follows: