![]() |
#6 |
NavAx
|
Цитата:
X++: select sum(TOR_QuantityOperation) from prodjournalroute where prodjournalroute.TransDate >= FromDate && prodjournalroute.TransDate <= ToDat join prodtable where prodtable.ProdId == prodjournalroute.ProdId join tor_Worktable group by WorkGroup where tor_Worktable.Code == prodTable.tor_WorkCode && (tor_Worktable.WorkGroup == TOR_WorkGroup::KR || tor_Worktable.WorkGroup == TOR_WorkGroup::TR || tor_Worktable.WorkGroup == TOR_WorkGroup::SR || tor_Worktable.WorkGroup == TOR_WorkGroup::TPIR) join tor_ordersobj where tor_ordersobj.ProdId == prodtable.ProdId join tor_eo_table where tor_eo_table.EO_Id == tor_ordersobj.EOId && tor_eo_table.RAssetId == rassettable.AccountNum; |
|