22,207
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#A') is null
drop table #A
Go
Create table #A([序号] nvarchar(21),[A1] nvarchar(23),[A2] nvarchar(24))
Insert #A
select N'1',N'测试1',N'被测试1' union all
select N'2',N'测试2',N'被测试2' union all
select N'3',N'测试3',N'被测试3'
GO
if not object_id(N'Tempdb..#B') is null
drop table #B
Go
Create table #B([序号] nvarchar(21),[A1] nvarchar(23),[A2] nvarchar(24))
Insert #B
select N'1',N'测试1',N'被测试1' union all
select N'2',N'测试2',N'被测试3' union all
select N'3',N'测试3',N'被测试2'
Go
--测试数据结束
SELECT #A.*
FROM #A
JOIN #B
ON #B.序号 = #A.序号
AND (
#B.A1 <> #A.A1
OR #B.A2 <> #A.A2
);