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 difference between ExecuteNonQuery, ExecuteReader, ExecuteScalar, Difference between Len and DataLength and 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 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.

If you want to know in-depth about Joins in SQL Server 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

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email