DELETE mtu,mt
FROM
pmms_msg_task_user AS mtu
LEFT JOIN pmms_msg_task AS mt
on mt.taskId = mtu.taskId
WHERE mt.resourceId = '33437b663f3d405d82bce97efaf30550'
表 as 别名 不能少 ,好多博主粘贴复制 过去就不能用了
DELETE mtu,mt
FROM
pmms_msg_task_user AS mtu
LEFT JOIN pmms_msg_task AS mt
on mt.taskId = mtu.taskId
WHERE mt.resourceId = '33437b663f3d405d82bce97efaf30550'
表 as 别名 不能少 ,好多博主粘贴复制 过去就不能用了