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