select sum(PostedQty), sum(PostedValue) from inventSum group by itemId, inventDimId
join InventDim
where InventDim.inventDimId == inventSum.InventDimId
join InventSerial
where InventSerial.InventSerialId == InventDim.inventSerialId &&
InventSerial.InventSerialId != '';
что вроде этого
|