civilwarjunky
IS-IT--Management
I am trying to group them by item# and total each item number. Example D19 = 1200 and do this for each item.
select soline.Invtid as 'Item #',soline.descr as 'Description',
soline.qtyord as 'QTY',soline.status,
sum(soline.qtyord)
from soline
where status='o'
Group by soline.Invtid,
soline.descr,
soline.qtyord,
soline.status
order by invtid
select soline.Invtid as 'Item #',soline.descr as 'Description',
soline.qtyord as 'QTY',soline.status,
sum(soline.qtyord)
from soline
where status='o'
Group by soline.Invtid,
soline.descr,
soline.qtyord,
soline.status
order by invtid