PeterCortiel

exec sql problems

Discussion created by PeterCortiel on Apr 30, 2017
Latest reply on Apr 30, 2017 by fmpdude

This does not work

 

Executesql("

Select d.enddate ,

sum(amount) ,

sum(intamount) from importdetail D

join importheader H

    on D.kf_importheader_id=H.kp_importheader_id

Group by d.enddate

where d.agency = ?

";

Char(9);

"";

"AES"

)

... Returns ?

This does:

Executesql("

Select

sum(intamount) from importdetail D

join importheader H

    on D.kf_importheader_id=H.kp_importheader_id

where d.agency = ?

";

Char(9);

"";

"AES"

)

Returns 1560.08

 

 

Does filemaker not support group by or does it have  a special version of it

 

How can I make the groupie work??

Outcomes