sql ： You can't specify target table '表名' for update in FROM clause

bus_customer是主表。bus_customer_info_student是副表。bus_customer_info_student表中存了外键

刚开始查询错误数据的时候是正常的

SELECT istu.* FROM `bus_customer` c
left join bus_customer_info_student istu on c.id = istu.customer_id
 where c.is_del =0 and c.customer_type_id = 1
and istu.id is null

想删除的时候就提示错误了：

delete from bus_customer where id in(
(SELECT c.id id FROM `bus_customer` c
left join bus_customer_info_student istu on c.id = istu.customer_id
 where c.is_del =0 and c.customer_type_id = 1
and istu.id is null)

You can't specify target table for update in FROM clause。意思是说，不能先select出同一表中的某些值，再update这个表(在同一语句中)改成酱婶儿的就好了

dele