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 

shaggy
Posting Yak Master

248 Posts

Posted - 2007-02-28 : 06:08:01
Hi,

How to write join condition using more than 2 tables


thanks
shaggy

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-28 : 06:09:15
[code]From a JOIN b on a.id = b.id
JOIN c on a.id = c.id[/code]

Note: Order of joining tables is immaterial for INNER joins, but not for OUTER joins.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -