|
ну можно и без этой таблицы
select InventDim.inventDimId, InventSum.ItemId, InventDim.inventSerialId, InventSerial.AdvertAction, SUM(InventSum.PostedQty)PostedQty, SUM(InventSum.PostedValue)PostedValue
FROM InventSum
JOIN InventDim on InventDim.inventDimId = InventSum.InventDimId
JOIN InventSerial on InventSerial.InventSerialId = InventDim.inventSerialId
where InventDim.inventSerialId<>''
GROUP BY InventDim.inventDimId,InventSum.ItemId, InventDim.inventSerialId , InventSerial.AdvertAction
order by InventSum.ItemId
|