SQL Subqueries (Microsoft Access SQL) [Access 2007 Developer Reference]

A subquery is a SELECT statement nested inside a SELECT, SELECT…INTO, INSERT…INTO, DELETE, or UPDATE statement or inside another subquery. ... Use the ALL predicate to retrieve only those records in the main query that satisfy the comparison with ...

msdn.microsoft.com