删除-我无法指定目标表? [英] Delete - I can't specify target table?

问题描述

为什么这个查询不起作用?

Why this query doesn't work?

DELETE FROM recent_edits 
WHERE trackid NOT IN 
     (SELECT DISTINCT history.trackid 
     FROM history JOIN recent_edits ON history.trackid=recent_edits.trackid 
     GROUP BY recent_edits.trackid)

我收到此消息:您无法在FROM子句中指定目标表"recent_edits"进行更新

I get this message : "You can't specify target table "recent_edits" for update in FROM clause

推荐答案

以这种方式尝试

DELETE FROM recent_edits 
WHERE trackid NOT IN 
     (select * from (SELECT DISTINCT history.trackid 
     FROM history JOIN recent_edits ON history.trackid=recent_edits.trackid 
     GROUP BY recent_edits.trackid) as t);

这篇关于删除-我无法指定目标表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！