How do I do this SQL statement in progress?

rpenridge

New Member
Hi all,

I have an SQL statement that I am trying to translate into progress. Can anyone help?


select lad_site as ttlad_site,
lad_loc as ttlad_loc,
lad_part as ttlad_part,
lad_lot as ttlad_lot,
lad_ref as ttlad_ref,
sum(lad_qty_all) as lad_qty_all
from lad_det
group by lad_site,
lad_loc,
lad_part,
lad_lot,
lad_ref .

I figure you need to use break bys to do it but I can't get the sub-totals for each of the grouped records. I always end up getting the running totals.

Thanks.
Rob
 
Top