Below are the strings that I copied from the Immediate window:
strIn:
Code:
SELECT [00_Master tbl].[MM ID], [01_Measure tbl].[free text], lkup01b_Dis.[Th A], lkup01b_Dis.Dis, [00_Master tbl].[Title], [00_Master tbl].[Description], [00_Master tbl].[Type], [00_Master tbl].[Calculation], [lkup02_Source of Data Needed].[Source of Data Needed, [lkup05_D and S].[Developer], [lkup07_Sets].[Set Name], [00_Master tbl].[Endorsement Status], [lkup03_Settings].[Setting], lkup08_References.Reference, [lkup06_Implementation Programs].[Implementation Program]
FROM ((((((((((((([00_Master tbl] LEFT JOIN [01_Measure tbl] ON [00_Master tbl].[MM ID]=[01_Measure tbl].[MM ID]) LEFT JOIN lkup01b_Dis ON [01_Measure tbl].[Dis Key]=lkup01b_Dis.lkup01b_ID) LEFT JOIN [05_D and s] ON [00_Master tbl].[MM ID]=[05_D and s].[MM ID]) LEFT JOIN [lkup05_D and S] ON [05_D and s].Developer=[lkup05_D and S].lkup05_ID) LEFT JOIN 08_References ON [00_Master tbl].[MM ID]=[08_References].[MM ID]) LEFT JOIN lkup08_References ON [08_References].Reference=lkup08_References.lkup01a_ID) LEFT JOIN [02_Source of data] ON [00_Master tbl].[MM ID]=[02_Source of data].[MM ID]) LEFT JOIN [lkup02_Source of Data Needed] ON [02_Source of data].Source=[lkup02_Source of Data Needed].lkup02_ID) LEFT JOIN [07_Measure sets] ON [00_Master tbl].[MM ID]=[07_Measure sets].[MM ID]) LEFT JOIN [lkup07_Sets] ON [07_Measure sets].[Set Key]=
[lkup07_Sets].lkup07_ID) LEFT JOIN [03_Setting of use] ON [00_Master tbl].[MM ID]=[03_Setting of use].[MM ID]) LEFT JOIN [lkup03_Settings] ON [03_Setting of use].Setting=[lkup03_Settings].lkup03_ID) LEFT JOIN [06_Implementation programs] ON [00_Master tbl].[MM ID]=[06_Implementation programs].[MM ID]) LEFT JOIN [lkup06_Implementation Programs] ON [06_Implementation programs].[Impl Prog Key]=[lkup06_Implementation Programs].lkup06_ID
WHERE ((([01_Measure tbl].[free text])="myKeyStr"));
strOut:
Code:
SELECT [00_Master tbl].[MM ID], [01_Measure tbl].[free text], lkup01b_Dis.[Th A], lkup01b_Dis.Dis, [00_Master tbl].[Title], [00_Master tbl].[Description], [00_Master tbl].[Type], [00_Master tbl].[Calculation], [lkup02_Source of Data Needed].[Source of Data Needed, [lkup05_D and S].[Developer], [lkup07_Sets].[Set Name], [00_Master tbl].[Endorsement Status], [lkup03_Settings].[Setting], lkup08_References.Reference, [lkup06_Implementation Programs].[Implementation Program] INTO [tblMyTable] FROM ((((((((((((([00_Master tbl] LEFT JOIN [01_Measure tbl] ON [00_Master tbl].[MM ID]=[01_Measure tbl].[MM ID]) LEFT JOIN lkup01b_Dis ON [01_Measure tbl].[Dis Key]=lkup01b_Dis.lkup01b_ID) LEFT JOIN [05_D and s] ON [00_Master tbl].[MM ID]=[05_D and s].[MM ID])
LEFT JOIN [lkup05_D and S] ON [05_D and s].Developer=[lkup05_D and S].lkup05_ID) LEFT JOIN 08_References ON [00_Master tbl].[MM ID]=[08_References].[MM ID]) LEFT JOIN lkup08_References ON [08_References].Reference=lkup08_References.lkup01a_ID) LEFT JOIN [02_Source of data] ON [00_Master tbl].[MM ID]=[02_Source of data].[MM ID]) LEFT JOIN [lkup02_Source of Data Needed] ON [02_Source of data].Source=[lkup02_Source of Data Needed].lkup02_ID) LEFT JOIN [07_Measure sets] ON [00_Master tbl].[MM ID]=[07_Measure sets].[MM ID]) LEFT JOIN [lkup07_Sets] ON [07_Measure sets].[Set Key]=[lkup07_Sets].lkup07_ID) LEFT JOIN [03_Setting of use] ON [00_Master tbl].[MM ID]=[03_Setting of use].[MM ID]) LEFT JOIN [lkup03_Settings] ON [03_Setting of use].Setting=[lkup03_Settings].lkup03_ID) LEFT JOIN [06_Implementation programs] ON [00_Master tbl].[MM ID]=[06_Implementation programs].[MM ID]
) LEFT JOIN [lkup06_Implementation Programs] ON [06_Implementation programs].[Impl Prog Key]=[lkup06_Implementation Programs].lkup06_ID WHERE ((([01_Measure tbl].[free text])="myKeyStr"));