Order By & Group By - together - error - ODBC

[Kranky]

From what i could tell by reading the filemaker ODBC developer guide both GROUP BY and ORDER BY sql statements are supported by filemaker.

I am unable to use these two statements together without receiving an error. The statements used separately work painlessly. Anybody else having the same problem?

the statment is similar to

Select * from table

group by item

order by total