Subqueries in SELECT or WHERE clauses that return more than one row must be used in combination with operators that are explicitly designed to handle multiple values, such as the IN operator.

When attempting the same for a subquery, the final select statement becomes a nested subquery rather than direct access to the subquery with a Select ...