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 | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3973100#3973100 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3973100 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user