yesm you can use the two together.... but that's not your problem... your problem is that you are using the Group By clause, but provided NO AGGREGATE FUNCTIONS (max, min, sum, avg, etc).... on the rest of the fields... that's what the error message is about... has NOTHING to do with the order by.

-tg