Nonaggregate Columns (*204)

SQL Server 6.0

ANSI-compatible. Nonaggregate columns must appear in the GROUP BY clause to be in the SELECT list or in columns in the SELECT list.

SQL Server 4.2x

Nonaggregate columns not listed in the GROUP BY clause can be in the SELECT list or in columns in the SELECT list.