aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

SQL Server- Difference Between Left Join and Left Outer Join

Sep 21, 2012

Here I will explain the difference between LEFT JOIN and LEFT OUTER JOIN in SQL Server.


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

Actually this one is very simple question but many of beginners are asking the same question that’s why I decided to write an article on it. Basically there is no difference between LEFT JOIN and LEFT OUTER JOIN both are same. Whenever we use LEFT JOIN keyword in SQL Server that is the LEFT OUTER JOIN only  

I already written brief article relating to Joins in SQL Server. Please check below article to know more about JOINS

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.