Is SQL GROUP BY multiple fields possible in Flexsim?

[MBJEBZSRG]

[ FlexSim 16.2.2 ]

In standard SQL the GROUP BY statement can take multiple comma separated fields, but in Flexsim it simply says "syntax error, unexpected identifier, expecting end of code". Am I simply doing it wrong or is there a way to do this?

query("SELECT [Field1], [Field2],SUM(Field1) FROM Table ORDER BY Field1, Field2");

[anthony_johnsonT83CM · Accepted solution]

Right now the group by will only take a single expression. If both fields are numbers, you could just combine them with some math expression: GROUP BY 10000 * Field1 + Field2