DELETE FROM CO05IN.ININVPRC WHERE IPPART IN (SELECT IPPART FROM CO05IN.ININVPRC left join CO05IN.ININVMST on IPPART = IMPART where IMPART is null);
在日志上创建:您无法在FROM子句中为更新指定目标表'ININVPRC' .
是什么造成的?
请注意使用MySQL 5.1版
1 回答
2
试试这种方式 .
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);
1 回答
试试这种方式 .