hi, there are 3 tables. 1,2,3
in 1st table 9 fields are there. 1st fld is keyfield ALL ARE RELATED ON THIS FIELD. in 2nd table there will be 3 records for each record in 1st table DESCRIPTON OF 4,5,6 fileds of the first table. in 3rd table also there will be 3 records for each record in 1st table DESCRIPTON OF 7,8,9 of the first table. HOW TO WRITE A QUERY TO GET THE FOLLOWING OUTPUT T1F1, T2F2, T3F3, T2DESC FOR T1F4, T2DESC FOR T1F5,T2DESC FOR T1F6, T3DESC FOR T1F7, T2DESC FOR T1F8,T2DESC FOR T1F9. PHANI.
