When a multiple-column subquery is included in the outer query's WHERE clause,the column names listed in the WHERE clause must be in the same order as they're listed in the subquery's SELECT clause.

Question

When a multiple-column subquery is included in the outer query's WHERE clause,the column names listed in the WHERE clause must be in the same order as they're listed in the subquery's SELECT clause.​

Quizplus · Accepted Answer

When using a multiple-column subquery, the order of the columns listed in the WHERE clause must match the order in the SELECT clause of the subquery. This is because the subquery returns multiple columns, and each column must correspond to the correct value in the outer query's WHERE clause.

When a Multiple-Column Subquery Is Included in the Outer Query's