更新emp表的员工工资,使它emp1表的员工工资相同
update emp e set e.sal = (select e1.sal from emp1 e1 where e.empno = e1.empno);
注意:where条件要关联正确,刚开始,关联为e.sal=e1.sal,即:update emp e set e.sal = (select e1.sal from emp1 e1 where e.sal = e1.sal);结果就是将emp表中员工工资变为0了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29056818/viewspace-768448/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29056818/viewspace-768448/