用下面语句更新字段
先用:
updata NODEDOCUMENT_1_T a set APPLICANT = (select max(d.FIRSTNAME) from pubr.sw2dnexusdate_orgpeople@old c,pubr.orgpeople@old d
where c.subno = d.participantno AND c.mainno = a.TRANSACTIONID AND c.sortid=5);
再用
update NODEDOCUMENT_1_T a set APPLICANT=(select max(d.fullname)
from pubr.sw2dnexusdate_ORGORGANIZE@old c,pubr.ORGORGANIZE@old d
where c.subno = d.ORGANIZENO AND c.mainno = a.TRANSACTIONID AND c.sortid=5);
结果只有后面更新的字段,前面语句更新的全变为空值。第一句的TRANSACTIONID与第二句的TRANSACTIONID是不一样的。求高手解答
先用:
updata NODEDOCUMENT_1_T a set APPLICANT = (select max(d.FIRSTNAME) from pubr.sw2dnexusdate_orgpeople@old c,pubr.orgpeople@old d
where c.subno = d.participantno AND c.mainno = a.TRANSACTIONID AND c.sortid=5);
再用
update NODEDOCUMENT_1_T a set APPLICANT=(select max(d.fullname)
from pubr.sw2dnexusdate_ORGORGANIZE@old c,pubr.ORGORGANIZE@old d
where c.subno = d.ORGANIZENO AND c.mainno = a.TRANSACTIONID AND c.sortid=5);
结果只有后面更新的字段,前面语句更新的全变为空值。第一句的TRANSACTIONID与第二句的TRANSACTIONID是不一样的。求高手解答
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货