Подскажите как реализовать такой запрос в Axapte
Подскажите как реализовать такой запрос в Axapte
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
JOIN InventTable on InventSum.ItemId = InventTable.ItemId
where InventDim.inventSerialId<>''
GROUP BY InventDim.inventDimId,InventSum.ItemId, InventDim.inventSerialId , InventSerial.AdvertAction
order by InventSum.ItemId
|