What are the keys to Tables 2 and 3? --- On Thu, 6/26/08, dasaga_phani <[EMAIL PROTECTED]> wrote:
From: dasaga_phani <[EMAIL PROTECTED]> Subject: [Access VBA Central] Can I make Query ??? To: [email protected] Date: Thursday, June 26, 2008, 4:15 AM 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. [Non-text portions of this message have been removed]
