MDAC 2.5 SDK - ODBC Desktop Database Drivers

ORDER BY Clause Limitations

If a SELECT statement contains a GROUP BY clause and an ORDER BY clause, the ORDER BY clause can contain only a column in the result set or an expression in the GROUP BY clause.