[AccessD] SQL in-line subquery

That is exactly what it does.  I discovered it by accident when I tried
to use a subquery that way and discovered that the SQL editor switched
my regular parens to square brackets and a period.  I don't know how
anyone else might have found it.  All I can suggest is that you try it.
You will need to alias the in-line subquery in order to refer to its
fields in a join.

Charlotte Foust

-----Original Message-----
From: Heenan, Lambert [mailto:Lambert.Heenan at AIG.com] 
Sent: Thursday, May 08, 2003 6:57 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: RE: [AccessD] SQL in-line subquery


It seems to me that the [Select * from Foo].  syntax allows one to
create queries in Access that use a sub-query as the base table. In
other words you don't need a temporary table or an already saved query.
This is something I've often wished I could do, if only the [ ]. syntax
was documented somewhere. 

Which begs the question - just how did this special syntax get
discovered? It always intrigues me when someone pops out of the woods
and says "hey look at this undocumented feature..."

Lambert

> -----Original Message-----
> From:	Wortz, Charles [SMTP:CWortz at tea.state.tx.us]
> Sent:	Thursday, May 08, 2003 10:01 AM
> To:	accessd at databaseadvisors.com
> Subject:	RE: RE: [AccessD] SQL in-line subquery
> 
> Dave,
> 
> I have to agree with you.  From the article you cited, we can see how 
> to write regular subqueries.  So why the special []. syntax exists, 
> and what does it do that the regular subquery cannot do, still has not

> been explained.
> 
> Maybe somebody that is between projects will take the time to 
> investigate what []. does and will report back to us.  Many-to-Many is

> always looking for good articles.
> 
> Charles Wortz
> Software Development Division
> Texas Education Agency
> 1701 N. Congress Ave
> Austin, TX 78701-1494
> 512-463-9493
> CWortz at tea.state.tx.us
> 
> 
> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com