MySQL的DELETE查询问题与选择

Question

下面的查询：

DELETE FROM CO05IN.ININVPRC WHERE IPPART IN (SELECT IPPART FROM CO05IN.ININVPRC left join CO05IN.ININVMST on IPPART = IMPART where IMPART is null); 

创建此上的日志：您不能指定目标表“ININVPRC”在FROM子句更新。

这是什么造成的？

使用MySQL版本5.1注意事项

Answer 1

试试这种方法。

DELETE FROM CO05IN.ININVPRC WHERE IPPART IN (select * from (SELECT IPPART FROM CO05IN.ININVPRC left join CO05IN.ININVMST on IPPART = IMPART where IMPART is null) as t);