您没有在最后一条select语句中提及存在或不存在的条件...您只是简单地将and条件放在不存在或不存在或不存在的情况下.尝试将任何有效条件放在那.并且在第一个选择语句y r u中使用相同的表两次并且在没有任何别名的情况下进行联接，请尝试一次检查一次.

You didnt mention exist or not exist condition at the last select statement... u simply put the and condition without any exist or not exist or in or not in. Try to put any of the valid condition over there. And also in the first select statement y r u using same table twice and joining without any alias try to check that one also once.