两个查询结果，一个结果中包含另一结果，怎么把包含的结果去掉

[buddyli]

两个查询结果，一个结果中包含另一结果，怎么把包含的结果去掉

[yorbo]

请你具体点，包含是什么意思？

[僵哥]

要具体看资料是什么样的，你的查询是怎么样写来确认。

[buddyli]

select a from b

select a from c

b,c两个查询结果，b包含c,把b中包含c的结果去掉

[老宛]

--测试
create table #a(
a int,
b int
)
create table #b(
a int,
b int
)
insert into #a select 1,1
insert into #a select 2,1
insert into #a select 3,1
insert into #a select 4,1
insert into #a select 1,2
insert into #a select 2,2
insert into #a select 3,2

insert into #b select 1,1
insert into #b select 2,1
insert into #b select 3,1
insert into #b select 1,1
insert into #b select 5,1
--交集
select a,b from (
select distinct a,b from #a
union all
select distinct a,b from #b
) x group by a,b having count(*)>1
--A表减交集 这个应该就是你所要的结果
select a,b from (
select a,b from (
select distinct a,b from #a
union all
select distinct a,b from #b
) x group by a,b having count(*)=1
union all
select distinct a,b from #a
) y group by a,b having count(*)>1
--B表减交集
select a,b from (
select a,b from (
select distinct a,b from #a
union all
select distinct a,b from #b
) x group by a,b having count(*)=1
union all
select distinct a,b from #b
) y group by a,b having count(*)>1
drop table #a
drop table #b

[SWEET_SAINT]

select distinct bc.a
from (select a from b
union all
select a from c) bc

看 這樣可以嗎？