新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 MERGE INTO TMP2ADB50F1D5DD11EEACB30050562 IT USING( SELECT T2.FID, SUM(ISNULL(TKE.FBASEQTY, 0)) fbaselockqty, SUM(ISNULL(TKE.FSECQTY, 0)) fseclockqty FROM T_PLN_RESERVELINKENTRY TKE RIGHT OUTER JOIN TMP2ADB50F1D5DD11EEACB30050562 T2 ON (( (TKE.FSUPPLYINTERID = T2.FID AND TKE.FSUPPLYFORMID = 'STK_Inventory') AND (TKE.FBASEQTY > 0)) AND TKE.FLINKTYPE = '4') GROUP BY T2.FID ) IT2 ON (IT.FID = IT2.FID) WHEN MATCHED THEN UPDATE SET IT.FBASELOCKQTY = IT2.FBASELOCKQTY, IT.FSECLOCKQTY = IT2.FSECLOCKQTY; 返回 保存