At 13:06 2016-02-20, "jerry foote" jerryf@footegroup.com 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
Does that do what you want?
It means: For each combination of service.manifest_n, service.bill_of_la, service.release_no, service.frm_acct, service.source, and service.source_id in the service table, what is the total of service.units?
[snip]
Sincerely,
Gene Wirchenko