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.