select 补集 not in

领测软件测试网     SELECT * FROM DT_ROLES l WHERE l.OID NOT IN ( SELECT r.DT_ROLES_OID FROM DT_MEMBER_TYPE_ROLES_CONTRAST r,DT_ROLES l WHERE r.DT_ROLES_OID = l.OID AND r.OID=65127)

文章来源于领测软件测试网 https://www.ltesting.net/