how to join 3 or more tables in sql server

[10533]

Hi,,


I have a 4 tables need to join and retrieve the data...

Table 1

Tid - PK
Tname
a3
a4
a5

Table 2
Tid - FK
Tname
Lid-FK
Eid-FK
b3
b4
b5

Table3
Lid -PK
Lname
c3
c4

Table4

Eid - Pk
Ename
d2
d3
d4


SELECT Table1.Tid, Table1.Tname, Table2.b3, Table2.b4, Table2.b5,
Table3.Lname, Table4.Eid, Table3.Lid,Tabl e4.Lname, Table4.Fname
FROM Tools LEFT OUTER JOIN
Table2 ON Table2.Tid = Table2.Tid LEFT OUTER JOIN
Table3 ON Table2.Lid = Table3.Lid LEFT OUTER JOIN
Table4 ON Table2.Eid = Table4.Eid

when i am executing this only Tid and Tname columns are displaying.....


please help me out...
thanks in advance

[ck9663]

Not displayed? Or it's displaying but showing NULL? If it's showing NULL, it could mean there's no matching record on that table.

Happy Coding!!!

~~ CK