Introduction to subqueries
Using subqueries in the WHERE clause
Subqueries in the HAVING clause
Subquery comparison test
Quantified comparison tests with ANY and ALL
Testing set membership with IN conditions
Existence test
Outer references
Subqueries and joins
Nested subqueries
How subqueries work