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

[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 
  | 

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