.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

What is the difference between outer join and left outer join?

Posted By: priya     Posted Date: December 20, 2009    Points:2   Category :Sql Server
Hi,

What is the difference between outer join and left outer join? I am bit confused with inner join and left outer join. can you please help me to understand between outer join and left outer join?

Thanks,
Priya

Responses
Author: Prasanti Prusty             
Posted Date: December 20, 2009     Points: 5   

SQL Server doesn't Support "OUTER JOIN" It Supports "FULL OUTER JOIN".

INNER JOIN : It retrives only the common records exist in both the tables based on the "ON " Clause.

FULL OUTER JOIN : It retrives the common records exist in both the tables based on the "ON " Clause as well as other records exist in both the tables.

LEFT OUTER JOIN : It retrives the common records exist in both the tables based on the "ON " Clause as well as other records exist in tables which is specified at the LEFT Side of the "LEFT OUTER JOIN" Clause.

Regards,
Prasanti
Author: Abhisek Panda             
Posted Date: December 22, 2009     Points: 5   

You can go through my article "Combine different tables in SQL" for all type of join methods available in SQL.

http://www.dotnetspark.com/kb/1139-combine-different-tables-sql.aspx

Author: nishithraj             
Posted Date: December 23, 2009     Points: 5   

OUTER JOIN has 3 types


LEFT OUTER JOIN or LEFT JOIN

RIGHT OUTER JOIN or RIGHT JOIN

FULL OUTER JOIN or FULL JOIN

Author: nishithraj             
Posted Date: December 23, 2009     Points: 5   

Check the following url

http://msdn.microsoft.com/en-us/library/ms187518.aspx

Author: jay             
Posted Date: February 19, 2010     Points: 5   

hi assume u have two tables tableA and tableB both have some null records

full outer join returns the null values in ur output from both the tables TableA and tableB

where as

left outer join returns allthe records from left table that is tanleA and returns only matching values of tableB

Author: sriram             
Posted Date: October 28, 2011     Points: 20   

Hi,

1)Inner join
2)outer join(left outer join,Right outer join)
3)Full join
4)cross join
5)Self Join

Hope this will help

www.databaseresource.blogspot.com

Author: BitWise             
Posted Date: August 23, 2012     Points: 20   

1.INNER JOIN - Fetches the data if present in both the tables.

2.OUTER JOIN are of 3 types:

LEFT OUTER JOIN - Fetches the data if present in the left table.
RIGHT OUTER JOIN - Fetches the data if present in the right table.
FULL OUTER JOIN - Fetches the data if present in either of the two tables.

BitWise


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend