retrieve data from 4 tables

hi,

i have to retrieve data from 4 tables at a time...can anyone guide me in wrting a query for the same..

Ex:-

i have four fields f1,f2,f3,f4 which i need to retrieve from four tables t1,t2,t3,t4 where f4='A'

can anyone help me in this regd?

thanks in advance...

Quote:

Originally Posted by kmanjani

hi,

i have to retrieve data from 4 tables at a time...can anyone guide me in wrting a query for the same..

Ex:-

i have four fields f1,f2,f3,f4 which i need to retrieve from four tables t1,t2,t3,t4 where f4='A'

can anyone help me in this regd?

thanks in advance...

Should be something like:

select a.f1,b.f2,c.f3,d.f4 from t1 a,t2 b,t3 c,t4 d