sql查询比较两表不同数据与相同数据
以下举例是查询相同数据，否则则相反
方法一：
select * from A as x,B as y where x.a1=y.b1 and x.a2=y.b2 and x.a3=y.b3
方法二：
select * from tb INTERSECT --UNION select * from dataname.dbo.tb
以下举例是查询相同数据，否则则相反
方法一：
select * from A as x,B as y where x.a1=y.b1 and x.a2=y.b2 and x.a3=y.b3
方法二：
select * from tb INTERSECT --UNION select * from dataname.dbo.tb
