oracle mysql sql 根据一张表更新另一张表

update CDINFO.Dept_Dict tab1 set PART_FLAG = (select PART_FLAG from DICT.DEPARTMENT_DICT@zyhis4 tab2 where tab1.dept_code = tab2.dept_code) where exists (select 1 from DICT.DEPARTMENT_DICT@zyhis4 tab2 where tab1.dept_code = tab2.dept_code)
上一篇:Form表单的post 和get跳转区别


下一篇:python-generator生成杨辉三角