oracle 用update直接更新时,出现问题
用下面的语句更新,oracle出现“ORA-00933: SQL 命令未正确结束”。
update HR_DA_EMPLOYEE
set GJJZH = MP_ARCHIVES.FUND_CD from HR_DA_EMPLOYEE, MP_ARCHIVES where HR_DA_EMPLOYEE.ZGDA = MP_ARCHIVES.ZGDA
说明:两表都设置了相应的主键,用
select MP_ARCHIVES.FUND_CD from HR_DA_EMPLOYEE, MP_ARCHIVES
where HR_DA_EMPLOYEE.ZGDA = MP_ARCHIVES.ZGDA
语句输出也没问题,
请朋友指教,谢谢。