Previous Topic: Nesting SELECT StatementsNext Topic: Using a Subquery with IN

Nesting SELECT Statements › SELECT Statement in a WHERE Clause

SELECT Statement in a WHERE Clause

You use a SELECT statement in a WHERE clause to create a result table that limits the rows that can be retrieved by the outer SELECT statement.

Generally, the SELECT statement nested within a WHERE clause can return only one column.