Chapter 6: Subqueries

Overview

All the queries you ve seen so far in this book have contained just one SELECT statement. In this chapter, you will

• Learn how to place a SELECT statement within an outer SELECT , UPDATE , or DELETE statement. The inner SELECT statement is known as a subquery .

• Learn about the different types of subqueries and see how to use them.

• See how subqueries allow you to build up very complex statements from simple components .