[AccessD] Notation Question

Yes
Derived tables, very handy. 


Michael Maddison

DDI Solutions Pty Ltd
michael at ddisolutions.com.au
Bus: 0260400620
Mob: 0412620497 
www.ddisolutions.com.au
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, 14 June 2006 3:30 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Notation Question

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