select ItemId, sum(PostedQty), sum(PostedValue) from InventSum group by ItemId
join InventDimId,InventSerialId from InventDim where InventDim.inventSerialId != "" && InventDim.inventDimId = InventSum.InventDimId group by inventDimId,inventSerialId
join InventSerial where InventSerial.InventSerialId = InventDim.inventSerialIdgroup by AdvertAction
Помоему так (отпишись потом верно нет
)