Nesting SELECT Statements › Things to Remember about Subqueries

Things to Remember about Subqueries

• You usually use SELECT * in a subquery in an EXISTS predicate
• You must enclose the nested SELECT statement in parentheses
• You join the outer SELECT statement and the subquery when using the EXISTS predicate by comparing columns in the WHERE clause of the subquery
• You can use aliases to qualify column names