[AccessD] Notation Question

Yes.  What's your question?  

We've had discussions before about inline queries and their weird
punctuation, and I use aliases to make my SQL easier to read. 


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Tuesday, June 13, 2006 10: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