Subselect Query Memory Advantages

[Steve]

With the subselect query using a SELECT TABLEA.* FROM
TABLEA Where FIELD IN
(SELECT FIELD FROM TABLEB)syntax, is there any
savings of memory due to the fact that the TABLEB
doesn't appear in the upper part of the QBE screen
design view and only appears in the SQL statement?

 

[Van T. Dinh]

No, the data still needs to be brought into the memory.
The TableB still appear in the criteria row of the DBE.
More importantly, JET processes the SQL String, not the
QBE and the QBE is simply a graphical interpretation of
the SQL. Therefore the QBE is not the primary factor for
consideration.

OTOH, most people are more concerned about the efficency
(i.e. processing speed) of the query rather than the
memory usage (which is a factor in the query effciency).

HTH
Van T. Dinh
MVP (Access)