使用MINUS关键字来查询
如:
SELECT T.USERID, T.USERNAME
FROM TABLEONE T
WHERE USERID = '0001'
MINUS
SELECT T1.USERID, T1.USERNAME FROM TABLETWO T1 WHERE SIDS = 'kkda';
使用MINUS关键字来查询
如:
SELECT T.USERID, T.USERNAME
FROM TABLEONE T
WHERE USERID = '0001'
MINUS
SELECT T1.USERID, T1.USERNAME FROM TABLETWO T1 WHERE SIDS = 'kkda';