UPDATE salaries set salary=salary*1.1
where to_date='9999-01-01'and emp_no in (select emp_no from emp_bonus);

刚开始用的是另一种代码： select sal.emp_no from salaries as sal join emp_bonus as eb on sal.emp_no=eb.emp_no where to_date='9999-01-01'; -- 两表连接，先找出应加薪人的员工号；

update salaries set salary=salary*1.1 where emp_no in (select sal.emp_no from salaries as sal join emp_bonus as eb on sal.emp_no=eb.emp_no where to_date='9999-01-01'); 语法上没报错，然后执行时报错语句如下：

Error Code: 1093. You can't specify target table 'salaries' for update in FROM clause

这是为什么呢？？？一脸黑人问号~~~~