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.