RE: Problem with GROUP BY

On 2016-02-20 16:06, jerry foote wrote:

Thanks for all the feed back on the group by clause. This what I ended up with

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

jerry

Don't forget you can use numbers too, as someone else said.