3,491
社区成员
发帖
与我相关
我的任务
分享
SELECT TCAA.ACCOUNT
FROM TCAA
WHERE NOT EXISTS
(SELECT NULL FROM ABC_TEMP B WHERE TCAA.ACCOUNT = B.ACCOUNT)
select TCAA.account from TCAA
minus
select account from abc_temp
select TCAA.account from TCAA where not exists(
select 1 from abc_temp where abc_temp.account=TCAA.account));