[AccessD] SQL in-line subquery

Drew Wutka DWUTKA at marlow.com
Tue May 6 11:09:18 CDT 2003


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


More information about the AccessD mailing list