Click here to Skip to main content
15,908,768 members
Please Sign up or sign in to vote.
2.33/5 (2 votes)
See more:
can any one explain the differences between left and Left outer join ? (In all Perspectives like performance etc...)
Posted
Comments
dan!sh 3-Jan-14 3:35am    
CPallini 3-Jan-14 3:38am    
(virtual) 5.
coded007 3-Jan-14 4:02am    
I know that d@nish but i didn't find any performance..... like this but it has it not clear
CPallini 3-Jan-14 3:39am    
Don't be afraid of using Google or reading the documentation.
coded007 3-Jan-14 4:04am    
I read some where it differs while inserting bulk data and searching BOL files. I need explanation for this

 
Share this answer
 
Comments
Maciej Los 3-Jan-14 5:30am    
+5!
TechNet of Microsoft wote:
SQL Server uses the following ISO keywords for outer joins specified in a FROM clause:
  • LEFT OUTER JOIN or LEFT JOIN
  • RIGHT OUTER JOIN or RIGHT JOIN
  • FULL OUTER JOIN or FULL JOIN


source: Using Outer Joins[^]

LEFT JOIN and LEFT OUTER JOIN has the same meaning to MS SQL server.

Here is an excellent article about joins: Visual Representation of SQL Joins[^] which ight help you to understand how it works!
 
Share this answer
 
v2
There is absolutely no difference between LEFT JOIN and LEFT OUTER JOIN. The same is true for RIGHT JOIN and RIGHT OUTER JOIN. When you use LEFT JOIN keyword in SQL Server, it means LEFT OUTER JOIN only.


Both are same. The word OUTER is optional

refer this:-
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]
 
Share this answer
 
Comments
Maciej Los 3-Jan-14 5:30am    
+5!
TrushnaK 3-Jan-14 5:41am    
thanks Maciej.....

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900