RE: Problem with GROUP BY

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

-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of jerry foote Sent: Saturday, February 20, 2016 1:30 PM To: 'ProFox Email List' Subject: Problem with GROUP BY

When I try to execute the code below i get error message group by error

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 service.release_no INTO CURSOR mytotla ORDER BYrelease_no

If anyone can spot the problem I would appreciate a heads up

Thanks Jerry

--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

[excessive quoting removed by server]