[AccessD] Notation Question

Martin Reid mwp.reid at qub.ac.uk
Tue Jun 13 12:29:48 CDT 2006


Anyone use this notation in Access
 

Example: Jet - SELECT x.a.AAAA, x.b.AAAA

                          FROM [SELECT a.AAAA, b.AAAA FROM table1 a Inner Join Table2 b On a.ID = b.ID]. AS x

 

 

                 SQL - SELECT x.Field1, x.Field2 FROM [SELECT a.AAAA as Field1, b.AAAA as Field2

                  FROM table1 a Inner Join Table2 b On a.ID = b.ID]. AS x

 

 

Martin
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 
 


More information about the AccessD mailing list