How can i write join query for three tables. [Resolved]

select f.col,f.col1..... ,s.col,s.col1 ..... from table1 inner join table2 on f.col=s.col inner join table3 on f.col or s.col=t.col  where f.col=something

Thanks&Regards
LakshmiNarayana Nalluri.

sriram

SELECT * FROM TABLE1



INNER JOIN TABLE2 ON TABLE1.COLUMNNAME=TABLE2.COLUMNNAME



JOIN



TABLE3 ON TABLE2.COLUMNNAME=TABLE3.COLUMNNAME



WHERE TABLE2.COLUMNNAME='XYZ'

sriram

Ajay
ajaypatelfromsanthal.blogspot.in