This 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.
Introducing subqueries
Introduction
Single-row and multiple-row subqueries
Using subqueries instead of joins