Are you trying to use GROUP BY in x++

Yes, I know, it is far from Oracle. But anyway...the syntax in the SQL world is

SELECT orderheader, sum(ordervalue)
FROM some_table
WHERE some criterias
GROUP BY orderheader

But when in x++ the order is another...

SELECT orderheader, sum(ordervalue)
FROM some_table
GROUP BY orderheader
WHERE some criterias

 I mean...come on! What the ...well. What is going on?