2) Right Outer Join -> It is also known as Right join . In right join all the content of right table will come in resultant and from the left table only matching rows will come . If no rows is matched from left table then null value will be returned .
select table1.column1 , table2.column2 ..from table1 right join table2 on table1.column_name = table2.column_name ;
Example of Right join :
First Table name : Employee_Info