[jboss-user] [EJB 3.0] - Group By Error

I get the following execption: java.sql.SQLException: Not in aggregate function or group by clause: when I try to run this EQL statement: select p.agency.name, p.customer.name, sum(p.amount) | from Payment p | group by p.agency.name, p.customer.name | having p.date between :startDate and :endDate If I change the group by statement to this: group by p.agency.name, p.customer.name, p.date Then the error goes away, but obviously I don't get the result I wanted. Any thoughts? Am I doing something wrong? Or is this a bug? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972738#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...