![]() |
#11 |
Участник
|
Цитата:
Сообщение от Евгений88
![]() А разве при этом:
X++: SELECT WITH SELECT_ORDER, NESTED_LOOP, FORCE_PLACEHOLDERS INDEXISHINT SUM(PostedQty), SUM(PostedValue), SUM(PhysicalValue), SUM(Deducted), SUM(Registered), SUM(Received), SUM(Picked), SUM(ReservPhysical), SUM(ReservOrdered), SUM(OnOrder), SUM(Ordered), SUM(Arrived), SUM(QuotationReceipt), SUM(QuotationIssue), SUM(PhysicalInvent), SUM(PostedValueSecCur_RU), SUM(PhysicalValueSecCur_RU), SUM(AvailPhysical), SUM(AvailOrdered) FROM InventSum USING INDEX ClosedItemDimIdx WHERE ((Closed = )) JOIN INDEXISHINT * FROM InventDim GROUP BY InventDim.InventLocationId ASC USING INDEX DimIdIdx WHERE InventSum.InventDimId = InventDim.inventDimId JOIN ItemId, SotrOrder FROM X_table GROUP BY X_table.SotrOrder, X_table.ItemId ASC WHERE X_table.ItemId = InventSum.ItemId Группировка по номенклатуре в InventSum не просто так ведь стоит. X++: .....JOIN ItemId, SotrOrder FROM X_table GROUP BY X_table.SotrOrder, X_table.ItemId ASC
__________________
-Ты в гномиков веришь? -Нет. -А они в тебя верят, смотри, не подведи их. |
|