[Ivan Mischenko]

Встретил следующий запрос:
Выглядит примерно так:
select sum(PostedQty),
sum(PostedValue),
from inventSum
where inventSum.itemId == _itemId &&
inventSum.configId == _configId &&
inventSum.closed == NoYes::No
join tableID from inventDim
where (inventDim.InventDimId == inventDimId) &&
(inventDim.InventLocationId == inventDimCriteria.InventLocationId ||
! inventDimParm.InventLocationIdFlag) &&
(inventDim.InventBatchId == inventDimCriteria.InventBatchId ||
! inventDimParm.InventBatchIdFlag) &&
(inventDim.WMSLocationId == inventDimCriteria.WMSLocationId ||
! inventDimParm.WMSLocationIdFlag) &&
(inventDim.WMSPalletId == inventDimCriteria.WMSPalletId ||
! inventDimParm.WMSPalletIdFlag) &&
(inventDim.InventSerialId == inventDimCriteria.InventSerialId ||
! inventDimParm.InventSerialIdFlag) &&
(inventDim.InventGTDId_RU == inventDimCriteria.InventGTDId_RU ||
! inventDimParm.InventGTDIdFlag_RU);
непонятен этот код: "join tableID from inventDim"