作者:惠嘟du | 来源:互联网 | 2023-05-18 04:23
SELECT*FROMDT_ROLESlWHEREl.OIDNOTIN(SELECTr.DT_ROLES_OIDFROMDT_MEMBER_TYPE_ROLES_CONTRASTr
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)
欢迎大家阅读《select 补集 not in_sqlserver》,跪求各位点评,若觉得好的话请收藏本文,by