There are not enough columns to match the subquery select list.
Message Text
There are not enough columns to match the subquery select list.
Explanation
The SELECT statement needs to include the same number of columns that the embedded subquery returns.
See Also
Expressions
Query Fundamentals
Subquery Fundamentals
Using the Select List