--错误写法:
update JFP_DEPT_copy a
set a.de_name = (select b.de_name from JFP_DEPT_copy b
where b.de_deptcode = a.de_parentcode) + a.de_name
set a.de_name = (select b.de_name from JFP_DEPT_copy b
where b.de_deptcode = a.de_parentcode) + a.de_name
---正确写法: 要修改的表不能命名别名,可以用表名当做别名
update JFP_DEPT
set de_name = (select b.de_name from JFP_DEPT b
where b.de_deptcode = JFP_DEPT.de_parentcode) + JFP_DEPT.de_name
where JFP_DEPT.de_parentcode != '00';
set de_name = (select b.de_name from JFP_DEPT b
where b.de_deptcode = JFP_DEPT.de_parentcode) + JFP_DEPT.de_name
where JFP_DEPT.de_parentcode != '00';