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
 Transact-SQL (2005)
 Joins??

Author  Topic 

mageshks
Yak Posting Veteran

59 Posts

Posted - 2008-06-17 : 09:35:33
Hi all,

What is happening internally when a join is performed ?.
Why there are two outer joins as both of them performing the
same opertion?.Use left join key word and swap the tables , its will
perform a right join .Is that correct?

Thanks in advance

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-17 : 09:38:31
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104951

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -