AND M.WATERMARK NOT IN ('IATF', 'G') NOT IN会将空值也筛选掉 如果不筛选掉空值,可以这样写 AND NVL(M.WATERMARK,'@@') NOT IN ('IATF', 'G')