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

Wednesday, 20 September 2006

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#...

Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[EJB 3.0] - Re: Group By Error