基础问题求教
有两个select语句 ,我想把它们结合起来并去重请教
select *from reportA where reportA.网元名称 not in (select reportB.网元名称 from reportB)
select * from reportA where checksum(*) not in (select checksum(*) from reportB)
select * from (
select * from reportA where reportA.网元名称 not in (select reportB.网元名称 from reportB)
union all
select * from reportA where checksum(*) not in (select checksum(*) from reportB)
)a
group by 全部列名
having count(1)=1