[AccessD] SQL in-line subquery

Charlotte Foust cfoust at infostatsystems.com
Tue May 6 11:19:13 CDT 2003


As I recall, the help files did NOT include anything on the [...]
syntax.  I stumbled over that myself in 97 but never found anything in
the help files except on regular subqueries.

Charlotte Foust

-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Tuesday, May 06, 2003 8:09 AM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] SQL in-line subquery


Actually, 'in-line' queries or subqueries are described in Access 97's
help files.  Just look up SQL Subqueries, or just subqueries.

Drew

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Tuesday, May 06, 2003 10:12 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL in-line subquery


Hi Jim

> <Snip>
> Those not familiar with the strange [..]. syntax may look up the 
> archives for "SQL in-line subquery" <Snip>

> Since I was (am) unfamiliar with this concept, I did look it up. I 
> have a few questions.

> 1.  Does this method run faster than a nested query?

A saved and compiled nested query may run faster. Haven't done any
testing though.

> 2.  What are the pitfalls?

One is that no documentation is available as far as I know.

> 3.  What are the benefits?

That you can avoid temporary tables or subqueries. All code is in one
query which is an advantage if you build it from VBA code.

/gustav

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list