第1个回答 推荐于2016-07-23
可以
例如:
1 update:
update dept
set dname = 'ORACLE'
where deptno in
(select a.deptno from emp a left join dept b on a.deptno = b.deptno);
2 delete:
delete dept
where deptno in
(select a.deptno from emp a left join dept b on a.deptno = b.deptno);本回答被提问者和网友采纳