2 Replies Latest reply on Sep 20, 2006 5:58 PM by John Gilbert

    Group By Error

    John Gilbert Apprentice

      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?