22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT A.[column1] CA, B.[column1] CB,
ISNULL(A.[column2], B.[column2]) [column2],
ISNULL(A.[column3],B.[column3]) [column3]
FROM A FULL JOIN B
ON A.[column2]=B.[column2] AND A.[column3]=B.[column3]
select a.column1,b.column1,a.column2,a.column3 from #A a,#B b
where a.[column2]=b.[column2] and a.column3=b.column3