17,377
社区成员
发帖
与我相关
我的任务
分享
update employee set
deptno=(select deptno from department where department_name='name') where
employee_id='id'
Update emp
Set deptno = '60'
Where Exists (
Select 1 From dept
Where emp.Deptno = dept.Deptno
)