left and lef outer join. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

left and lef outer join.

Author

Topic

nitinnjp
Starting Member

6 Posts

Posted - 2011-03-31 : 06:22:27

Anybody can tell me what is difference between left join and left outer join with example.

nitin patil

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2011-03-31 : 06:42:17

"left join" = "left outer join"

word outer is optional

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-03-31 : 06:59:38

JOIN = INNER JOIN
LEFT OUTER JOIN = LEFT JOIN
RIGHT OUTER JOIN = RIGHT JOIN
FULL OUTER JOIN = FULL JOIN

--------------------------
http://connectsql.blogspot.com/

anita.86
Starting Member

21 Posts

Posted - 2011-12-10 : 00:15:58

Hi,

keyword OUTER is optional, so if you use it or not it makes no difference.

N/A

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources