34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM [192.168.1.108].[MyTestDB].dbo. A
WHERE CompanyKey=5 AND NOT EXISTS
(
SELECT IC_ID
FROM B
WHERE A.CompanyKey=B.CompanyKeyAND A.ICID=B.ICID
)
SELECT *
FROM [192.168.1.108].[MyTestDB].dbo. A
WHERE CompanyKey=5 AND NOT EXISTS
(
SELECT ICID
FROM B
WHERE CompanyKey='5' AND ICID='0008007062'
)
这样试试呢