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 Subquery Fundamentals
Query Fundamentals Using the Select List

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.