This content has been marked as final.
Show 2 replies
-
1. Re: Group By Error
epbernard Sep 19, 2006 7:32 PM (in response to jgilbert)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 -
2. Re: Group By Error
jgilbert Sep 20, 2006 5:58 PM (in response to jgilbert)Thanks!
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