MySQL 删除错误 - 无法在 FROM 子句中指定更新目标表

Question

伙计们，我正在尝试使用嵌套查询从数据库中删除一些记录:

delete from imageviewer_crreviewerformdata
where imageviewer_crreviewerformdata.FormDataId in
(select distinct imageviewer_crreviewerformdata.FormDataId
from imageviewer_crreviewerformdata,imageviewer_crtask
where imageviewer_crreviewerformdata.TaskId = imageviewer_crtask.TaskId
and imageviewer_crtask.RevProtId in (1));

我得到了众所周知的 mysql 异常。有人可以帮忙制定查询吗？

Answer 1

delete d 
from imageviewer_crreviewerformdata d
inner join imageviewer_crtask t on d.TaskId = t.TaskId
where t.RevProtId in (1)