Вопрос по SysQueryRun

[kashperuk]

А что это за запрос у вас такой: ???

X++:

SELECT ItemId, ItemGroupId, INVALID FIELD, INVALID FIELD
FROM InventTable GROUP BY InventTable.ItemId ASC, InventTable.ItemGroupId ASC, InventTable.INVALID FIELD ASC, InventTable.INVALID FIELD ASC
JOIN SUM(PostedQty), SUM(Received), SUM(Deducted), SUM(Registered), SUM(Picked)
FROM InventSum WHERE InventTable.ItemGroupId = InventSum.ItemId
JOIN inventDimId, InventLocationId FROM InventDim GROUP BY InventDim.inventDimId ASC WHERE InventSum.InventDimId = InventDim.inventDimId

Опередили.

[Protey]

Цитата:

Сообщение от kashperuk

А что это за запрос у вас такой: ???

X++:

SELECT ItemId, ItemGroupId, INVALID FIELD, INVALID FIELD
FROM InventTable GROUP BY InventTable.ItemId ASC, InventTable.ItemGroupId ASC, InventTable.INVALID FIELD ASC, InventTable.INVALID FIELD ASC
JOIN SUM(PostedQty), SUM(Received), SUM(Deducted), SUM(Registered), SUM(Picked)
FROM InventSum WHERE InventTable.ItemGroupId = InventSum.ItemId
JOIN inventDimId, InventLocationId FROM InventDim GROUP BY InventDim.inventDimId ASC WHERE InventSum.InventDimId = InventDim.inventDimId

Опередили.

А как из query выдернуть такой запрос, в виде select?