RE: Problem with GROUP BY

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

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