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