Introduction:
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
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. |
|||
|
|||
2 comments :
nhgjhg
Actually left outer & Right outer join is performed , For avoiding duplicate entry while insertion into one table
Note: Only a member of this blog may post a comment.