mysql - 加入删除时出现语法错误

Question

我正在使用删除一些记录，

delete FROM product_to_category c inner JOIN product_description d 
ON c.product_id = d.product_id
WHERE c.category_id IN (3, 6)
GROUP BY c.product_id
HAVING COUNT(DISTINCT c.category_id) = 2
ORDER BY d.name asc

但它返回语法错误以在 c inner JOIN product_description 附近使用......

谁能告诉我如何正确构建查询

任何建议将不胜感激

Answer 1

如果您有多个表(连接)，您需要指定要删除的表。

DELETE T1
FROM T1
INNER JOIN T2 ON T1.key = T2.key
WHERE condition