[AccessD] SQL in-line subquery

Gustav Brock gustav at cactus.dk
Thu May 8 10:15:12 CDT 2003


Hi Lambert

> 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..."

It was someone called Paul in July 2001 that mentioned it as common
knowledge ...

/gustav



More information about the AccessD mailing list