User's Guide Part II. TutorialsThis chapter shows how to use the results of one query as part of another SELECT statement. This is a useful tool in building more complex and informative queries.
Preparing to use subqueries A simple subquery Comparisons using subqueries Using subqueries instead of joins