库存账龄报表分析报错
云社区用户15IX1851
687次浏览
编辑于2017年06月02日 10:02:57
库存账龄报表分析报错 用同样方法分析有两个事业分析没有问题 有两个事业部分析就报错？ 查询出现异常。MERGE 语句试图多次更新或删除同一行。目标行与多个源行匹配时会出现这种情况。MERGE 语句无法多次更新/删除目标表的同一行。请简化 ON 子句，以确保目标行最多与一个源行匹配，也可以使用 GROUP BY 子句对源行分组。
merge into TMPE2848992473611E7812B40F2E9D IT using ( SELECT FGUID,FMATERIALID,FSTOCKORGID,FOWNERTYPEID,FOWNERID,FKEEPERTYPEID,FKEEPERID,
FSTOCKID,FStockLocId,FSTOCKSTATUSID,FAuxPropId,FLOTID,FPRODUCEDATE,FEXPIRYDATE,FBOMID,FMTONO from TMPE2848991473611E7812B40F2E9D ) IT2
ON (IT.FMATERIALID=IT2.FMATERIALID
AND IT.FSTOCKORGID=IT2.FSTOCKORGID
AND IT.FOWNERTYPEID=IT2.FOWNERTYPEID
AND IT.FOWNERID=IT2.FOWNERID
AND IT.FKEEPERTYPEID=IT2.FKEEPERTYPEID
AND IT.FKEEPERID=IT2.FKEEPERID
AND IT.FSTOCKID=IT2.FSTOCKID
AND IT.FSTOCKLOC=IT2.FStockLocId
AND IT.FSTOCKSTATUSID=IT2.FSTOCKSTATUSID
AND IT.FAuxPropId=IT2.FAuxPropId
AND IT.FLOTID=IT2.FLOTID
AND (IT.FPRODUCEDATE=IT2.FPRODUCEDATE OR (IT.FPRODUCEDATE IS NULL AND IT2.FPRODUCEDATE IS NULL))
AND (IT.FEXPIRYDATE=IT2.FEXPIRYDATE OR (IT.FEXPIRYDATE IS NULL AND I
merge into TMPE2848992473611E7812B40F2E9D IT using ( SELECT FGUID,FMATERIALID,FSTOCKORGID,FOWNERTYPEID,FOWNERID,FKEEPERTYPEID,FKEEPERID,
FSTOCKID,FStockLocId,FSTOCKSTATUSID,FAuxPropId,FLOTID,FPRODUCEDATE,FEXPIRYDATE,FBOMID,FMTONO from TMPE2848991473611E7812B40F2E9D ) IT2
ON (IT.FMATERIALID=IT2.FMATERIALID
AND IT.FSTOCKORGID=IT2.FSTOCKORGID
AND IT.FOWNERTYPEID=IT2.FOWNERTYPEID
AND IT.FOWNERID=IT2.FOWNERID
AND IT.FKEEPERTYPEID=IT2.FKEEPERTYPEID
AND IT.FKEEPERID=IT2.FKEEPERID
AND IT.FSTOCKID=IT2.FSTOCKID
AND IT.FSTOCKLOC=IT2.FStockLocId
AND IT.FSTOCKSTATUSID=IT2.FSTOCKSTATUSID
AND IT.FAuxPropId=IT2.FAuxPropId
AND IT.FLOTID=IT2.FLOTID
AND (IT.FPRODUCEDATE=IT2.FPRODUCEDATE OR (IT.FPRODUCEDATE IS NULL AND IT2.FPRODUCEDATE IS NULL))
AND (IT.FEXPIRYDATE=IT2.FEXPIRYDATE OR (IT.FEXPIRYDATE IS NULL AND I
