SQL Server- Difference Between Left Outer Join and Right Outer Join

Introduction:

Here I will explain differences between left outer join and right outer join in SQL Server.

Description:

In previous posts I explained  many articles relating to SQL Server. Now I will explain the difference between left outer join and right outer join in SQL Server.

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 differencebetween 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.

If you want to know in-depth about Joins in SQLServer please check below link in that post I explained each join clearly with examples

Left Join, Right Join, Cross Join,Inner Join, Self Join, Full Outer Joins in SQL Server