There are not enough columns 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 How to: Create Subqueries (Visual Database Tools).