Joining a Table with Itself - 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

General SQL Server Forums

New to SQL Server Programming

Joining a Table with Itself

Author

Topic

Plotin
Starting Member

21 Posts

Posted - 2005-12-06 : 13:01:20

Plotin
Starting Member

21 Posts

Posted - 2005-12-06 : 13:10:59

Formatting of the posting above is pretty messed up.
Can someone tell me how to use HTML in a message?

Below is a select statement which hopefuly exemplifies what is tried to be asked

select rgtwo.regionid,rgtwo.city,rgthree.regionid,rgthree.city
from Region as rgone(nolock) join Region as rgtwo(nolock)
on rgone.regionid = rgtwo.regionid
and rgone.regionid = 1 left outer join region as rgthree(nolock)
on rgtwo.regionid = rgthree.regionid
and rgthree.city = 'New York'

Thanks

Plotin

SamC
White Water Yakist

3467 Posts

Posted - 2005-12-06 : 15:35:12

HTML in a message: Click the "Forum Code" link to the left of the Message text box for help.

Notice how [ code ] will format your query:


select rgtwo.regionid,rgtwo.city,rgthree.regionid,rgthree.city
from Region as rgone(nolock) join Region as rgtwo(nolock) 
  on rgone.regionid = rgtwo.regionid
 and rgone.regionid = 1 left outer join region as rgthree(nolock)
  on rgtwo.regionid = rgthree.regionid
 and rgthree.city = 'New York'

SamC
White Water Yakist

3467 Posts

Posted - 2005-12-06 : 15:37:55

It's a personal style thing, but I like to see my tables in a column like this:


select rgtwo.regionid,rgtwo.city,rgthree.regionid,rgthree.city
  from Region as rgone(nolock) 
  join Region as rgtwo(nolock) 
       on rgone.regionid = rgtwo.regionid
       and rgone.regionid = 1 
  left outer join region as rgthree(nolock)
       on rgtwo.regionid = rgthree.regionid
       and rgthree.city = 'New York'

Shouldn't the first join be an INNER JOIN or LEFT OUTER JOIN?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources