22,207
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM [dataA].[dbo].[table1] WHERE cardNo not in(
SELECT cardNo FROM [dataB].[dbo].[table1]
)
SELECT * FROM [dataA].[dbo].[table1] a left join [dataB].[dbo].[table1] b on a.cardNo = b.cardNo where b.cardNo is null
SELECT * FROM [dataA].[dbo].[table1] WHERE cardNo not in(
SELECT cardNo FROM [dataB].[dbo].[table1] where cardNo is not null
)
或者参考二楼