Mysql错误：You can‘t specify target table ‘works‘ for update in FROM clause

背景：

drop table if exists works;
create table if not exists works(
employee_id int,
employee_name varchar(32),
city varchar(32),
salary varchar(32),
 FOREIGN key(employee_id) REFERENCES employee(employee_id)
)character set utf8;

insert into
works
values
(1,"11","西安","10000"),
(2,"22","成都","20000"),
(3,"33","北京","30000"),
(4,"44","成都","40000"),
(5,"55","西安","50000");

需求：
找到工资没超过二万的第一银行的经理将他们的工资提高10%

问题：
一开始的代码

update
works
set
salary=salary*1.1
where
employee_id in (select employee_id from works where salary<=20000);

错误：
You can’t specify target table ‘works’ for update in FROM clause（不能在FROM子句中指定目标表“works”进行更新）

解决办法：

update
works
set
salary=salary*1.1
where
employee_id in (select z.employee_id from  ((select employee_id from works where salary<=20000)z));
--部分解释：z可以随意命名，按这种格式写是没有问题的。

至于为什么，没看懂。大佬们都说是 使用中间表 让mysql认为不是在同时对一个表进行查询和修改。
如果有大佬知道具体的，感谢补充~~