1、更新关联数据
update emp set (job,sal,comm)=(
select job,sal,comm from emp where ename='SMITH')
where ename='SCOTT';
2、复制表数据
update employee set deptno=
(select deptno from emp where empno=7788)
where job=(select job from emp where empno=7788);
//将同7788员工岗位相同的员工都划入7788员工所属部门