There are not enough columns to match the subquery select list.

Troubleshooting SQL Server

Troubleshooting

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