All the queries you’ve seen so far in this book have contained just one SELECT statement. In this chapter, you will learn the following:
How to place an inner SELECT statement within an outer SELECT, UPDATE, or DELETE statement. The inner SELECT is known as a subquery.
The features of the different types of subqueries.
How subqueries allow you to build up very complex statements from simple components.