In this chapter, you’ll learn how to perform the following tasks:
Place an inner
SELECTstatement within an outer SQL statement. The inner
SELECTis called a subquery.
Use the different types of subqueries.
Create complex statements from simple components.
Types of Subqueries
There are two basic types of subqueries: