mysql - 我如何使用子选择或左连接来执行此删除查询

Question

我正在尝试从我的任务表中删除任务，其中任务 ID 例如为 100，并且该任务由删除用户或其团队成员(在用户表中分配了较小的 user_role)创建

我想知道这样的事情是否会产生魔力，或者实现这一目标的正确方法是什么？

DELETE FROM tasks t LEFT JOIN users u ON u.user_id = 1 WHERE task_id = 677 
AND createdby 
IN((SELECT u1.user_id FROM users u1 WHERE u1.user_team = u.user_team 
AND taskrspnsble 
IN((SELECT u2.user_id FROM users u2 WHERE u2.user_role <= u.user_role))
))

Answer 1

我觉得我的逻辑解释的很清楚了？我刚刚想通了。正确答案在这里!

 DELETE FROM tasks 

WHERE task_id = 1 
AND createdby IN(
                (SELECT u1.user_id FROM users u1 WHERE u1.user_team 
                 IN
                 (SELECT u2.user_team FROM users u2 WHERE u2.user_role <= (SELECT u3.user_id FROM users u3 WHERE u3.user_id = 1)
                )
                ))