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'
Ajayajaypatelfromsanthal.blogspot.in
Login to post response