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