MySQL中使用LEFT JOIN后执行delete删除操作

DELETE
    a
FROM
    task_news a
LEFT JOIN
    temp_new b
ON
    a.ID = b.ID
WHERE
    b.UserID > 0