using nested joins in sql server 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Dear All,

I am trying to use nested joins in sql 2005.

something like this :

SQL

SELECT *
FROM TABLE1
LEFT JOIN TABLE2
    INNER JOIN TABLE3 ON TABLE2.ID = TABLE3.ID
ON TABLE1.ID = TABLE2.ID

However it is not working.
I read it some where that we can use nested join in this way but i have forgotten the source. Does anybody know about using nested joins in this fashion?

Any help would be much appreciated.

Regards,
Gopal

Posted 22-Dec-11 20:09pm

gopalgupta

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

uspatel · Answer 1 · 2011-12-22T20:12:00

Solution 1

see Discussion
nested-inner-joins

Posted 22-Dec-11 20:12pm

uspatel

Comments

gopalgupta 23-Dec-11 2:24am

i think the example is different to my question....
i doesn't state if i can use joins in the manner i am trying to ..

Sarvesh Kumar Gupta · Answer 2 · 2011-12-22T20:45:00

You have written query in wrong way. try this

SELECT *
FROM TABLE1
LEFT JOIN TABLE2  <-- Give "ON with condition" i.e. below "ON TABLE1.ID = TABLE2.ID"
    INNER JOIN TABLE3 ON TABLE2.ID = TABLE3.ID
ON TABLE1.ID = TABLE2.ID

<-- You can not add 2 ON condition with one join

Right Query will be :

SELECT *
FROM TABLE1
LEFT JOIN TABLE2  ON TABLE1.ID = TABLE2.ID
    INNER JOIN TABLE3 ON TABLE2.ID = TABLE3.ID

using nested joins in sql server 2005

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

using nested joins in sql server 2005

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us