[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