There are not enough values in the subquery select list.

The SELECT statement needs to include the same number of columns that the embedded subquery returns.

For more information, see Creating Subqueries.