This content has been marked as final. Show 2 replies
As per the spec
The HAVING clause must specify search conditions over the grouping items or aggregate functions that
apply to grouping items.
Same restriction as in SQL AFAIK
I changed the having to a where and everything is good.
select p.agency.name, p.customer.name, sum(p.amount) from Payment p where p.date between :startDate and :endDate group by p.agency.name, p.customer.name