[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
> 
> 
>