错误原因:
执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。
解决方案:
请将如下错误信息提单反馈:
[Execute provider[./sql/PT118623_fi_cpbc_table.sql], sql[UPDATE PROXY SET FREIMBURSECOMPANYID = (SELECT TOC.FID FROM T_ORG_BaseUnit TOC INNER JOIN T_ORG_UNITRELATION TOUR ON TOUR.FTOUNITID = TOC.FID INNER JOIN T_ORG_ADMIN TOA ON TOA.FID = TOUR.FFROMUNITID INNER JOIN T_ORG_TYPERELATION TOTR ON TOTR.FID = TOUR.FTYPERELATIONID WHERE ((TOTR.FFROMTYPE = 0 AND TOTR.FTOTYPE = 1) AND TOUR.FFROMUNITID IN (SELECT B.FADMINORGUNITID FROM T_ORG_POSITIONMEMBER A, T_ORG_POSITION B, T_BC_PROXYREIMBURSE C WHERE ((A.FISPRIMARY = 1 AND A.FPOSITIONID = B.FID) AND C.FREIMBURSEPERSONID = A.FPERSONID)))) FROM T_BC_PROXYREIMBURSE PROXY WHERE (PROXY.FPROXYTYPE = 0 AND (PROXY.FREIMBURSECOMPANYID IS NULL))] failed, sqlcode[512] sqlstat[21000],Causedby[子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后,或子查询用作表达式时,这种情况是不允许的。],DBType=[MS SqlServer]
]
推荐阅读