A subquery is a select statement that is nested inside another select, insert, update, or delete statement, inside a conditional statement, or inside another subquery.
You can also express subqueries as join operations. See Chapter 4, “Joins: Retrieving Data from Several Tables.”
