mysql - 从选择中删除

我正在尝试将下面的过程转换为删除过程，但似乎不起作用。

SELECT i08.pe01 AS fld1,
i08.pe02 AS fld11,
i08.pe03 AS fld21,
i08.nr01 AS nr0
FROM i08
LEFT JOIN i00 ON i08.pe01=i00.pno
WHERE  (i00.p9901 ='17' &&
i08.pe01 not in (SELECT distinct        i01_KIN.p01 AS fld81 FROM i01_KIN))

我在努力

DELETE FROM i08
USING i08, i00, i01_KIN
WHERE  (i00.p9901 ='17' &&
i08.pe01 not in (SELECT distinct     i01_KIN.p01 AS fld81 FROM i01_KIN))

但什么都没有。任何能帮忙的人请

最佳答案

如果我没搞错的话，你不应该使用&&而应该使用MySQL

DELETE FROM i08
USING i08, i00, i01_KIN
WHERE
(    i00.p9901 ='17'
 AND i08.pe01 NOT IN (SELECT distinct i01_KIN.p01 AS fld81 FROM i01_KIN)
)