Does anyone know a workaround on how to have the equivalent of HAVING clause in an AX2009 query? I know AX2012 already has this functionality but is there anyone who’s successful in doing this in AX2009?
For example, I want with the same result as this SQL statement:
SELECT ItemGroupId, COUNT() FROM INVENTTABLE
GROUP BY ItemGroupId
HAVING COUNT() < 100
Is there a way to do this?
Thanks in advance!