联合查询
表A
SKU AreaMedian LocationMedian
12 001 3096
13 001 3096
12 001 3097
14 005 3096
表B
Area Location
001 3096
001 3098
001 3097
002 3096
最后查询查询结果要是
001 3096
001 3097
005 3096
002 3096
001 3098
就是把两个表里面的这两个相同列中的
数据查询出来，相同的不要。不管哪个表只要有没出现过的都查询出来
[解决办法]
create table a
(
SKU int,
AreaMedian int,
LocationMedian int
)
go
create table b
(
Area int,
Location int
)
go
insert into a values(12,001,3096)
insert into a values(13,001,3096)
insert into a values(12,001,3097)
insert into a values(14,005,3096)
insert into b values(001,3096)
insert into b values(001,3098)
insert into b values(001,3097)
insert into b values(002,3096)
select AreaMedian,LocationMedian from a
union
select Area as AreaMedian,Location as LocationMedian from b
