使用 INTERSECT关键字求两部分数据集的交集
如:
SELECT T.USERID, T.USERNAME
FROM TABLEONE T
WHERE USERID = '0001'
INTERSECT
SELECT T1.USERID, T1.USERNAME FROM TABLETWO T1 WHERE SIDS = 'kkda';
使用 INTERSECT关键字求两部分数据集的交集
如:
SELECT T.USERID, T.USERNAME
FROM TABLEONE T
WHERE USERID = '0001'
INTERSECT
SELECT T1.USERID, T1.USERNAME FROM TABLETWO T1 WHERE SIDS = 'kkda';