RE: Problem with GROUP BY

When you have an aggregate (the sum), you should group by all the noon-aggregate fields.

You could use the numbers for each field. Group by 3,1,2,4,5,6

On February 20, 2016 2:53:12 PM EST, jerry foote jerryf@footegroup.com wrote:

I have adjusted the code as below and still get error message GROUP BY clause is missing or invalid. I am running vp8

SELECT manifest_n, bill_of_la, release_no, frm_acct, source, source_id, sum(units) as totat FROM SERVICE WHERE manifest_n=2512 AND bill_of_la="158401" GROUP BY release_no INTO CURSOR mytotla