In this chapter, you’ll learn how to perform the following tasks:
Place an inner
SELECT statement within an outer SQL statement. The inner
SELECT is 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: