not exists 版本SELECT  org.*,  u.rname AS unameFROM  exam_org org  LEFT JOIN exam_user u    ON org.ouid = u.uno WHERE NOT EXISTS    (SELECT      id    FROM      exam_org    WHERE id IN (8,0)      AND id = org.id)not in SELECT  org.*,  u.rname AS unameFROM  exam_org org  LEFT JOIN exam_user u    ON org.ouid = u.uno WHERE id not in(8,0)    由此可见，对于没有子查询来说 ，not in 和 not exists 应该是差不多的