Сообщение от
dim123
запрос
select t.itemname,s.itemid,sum(s.availphysical) as cnt
from inventsum s, inventdim d, inventtable as t
where s.availphysical<>0 and t.itemid=s.itemid and d.inventlocationid='616' and d.inventdimid = s.inventdimid
and s.dataareaid='hc' and s.itemid like '7%' and d.dataareaid='hc' and t.dataareaid='hc'
group by s.itemid,t.itemname order by s.itemid
висит