Subqueries place a SELECT statement inside another SQL statement. This chapter introduces scalar subqueries, IN, EXISTS, NOT EXISTS, and correlated subqueries, then compares when each form is useful.
Subqueries
Use one query's result inside another query