HR_DA_EMPLOYEE.ZGDA 和 MP_ARCHIVES.ZGDA不是一对一的关系update HR_DA_EMPLOYEE set GJJZH = (select MP_ARCHIVES.FUND_CD from HR_DA_EMPLOYEE, MP_ARCHIVES where HR_DA_EMPLOYEE.ZGDA = MP_ARCHIVES.ZGDA and HR_DA_EMPLOYEE.ZGDA is not null)
因为下面的语句返回多行数据(两表相匹配的) (select MP_ARCHIVES.FUND_CD from HR_DA_EMPLOYEE, MP_ARCHIVES where HR_DA_EMPLOYEE.ZGDA = MP_ARCHIVES.ZGDA and HR_DA_EMPLOYEE.ZGDA is not null) 那么,GJJZH=?将不唯一, 我想用一条语句将所有匹配的进行更新,sql server2000可以,不知oracle为什么不行?
and HR_DA_EMPLOYEE.ZGDA is not null)
同时保证 MP_ARCHIVES 以 ZGDA 为主键。
即可。
(select MP_ARCHIVES.FUND_CD from HR_DA_EMPLOYEE, MP_ARCHIVES where HR_DA_EMPLOYEE.ZGDA = MP_ARCHIVES.ZGDA
and HR_DA_EMPLOYEE.ZGDA is not null)
那么,GJJZH=?将不唯一,
我想用一条语句将所有匹配的进行更新,sql server2000可以,不知oracle为什么不行?