Difference Between Left Outer Join and Right Outer Join

Left Join or Left Outer Join:

The left outer join displays all the rows from the first table and matched rows from the second table. Here one more thing we need to remember that is Left Join is same as Left Outer Join only there is no difference between Left Join and Left Outer Join in SQL Server.

Right Join or Right Outer Join:

The right outer join displays all the rows from the second table and matched rows from the first table. Here one more thing is Right Join is same as Right Outer Join only there is no difference between right Join and right outer Join in SQL Server.