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
 General SQL Server Forums
 New to SQL Server Programming
 Joins ?

Author  Topic 

mageshks
Yak Posting Veteran

59 Posts

Posted - 2008-06-17 : 00:56:19
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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-17 : 01:07:04
http://www.sqlteam.com/article/writing-outer-joins-in-t-sql
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-06-17 : 09:41:57
you can't do better than this blog to understanding the guts of a query plan, including all the different join operators:

http://blogs.msdn.com/craigfr


elsasoft.org
Go to Top of Page
   

- Advertisement -