The SELECT statement needs to include the same number of columns that the embedded subquery returns.
For more information, see Creating Subqueries.