Hello
I use FM Pro 11.0v3 ADV
So here is my query and use the baselements plugin. The following code is correct, but I do not get any results. I think the oli.ID_Product in the having clause is a problem.
BE_FileMakerSQL ( "
SELECT oli.ID_Product, sum(oli."Quantity ordered")...