对表求差集

1, 差集

如，找出在b中出现，a中没有的部分

create table id_graph_negative_7day

as

select c.pcgid, c.appgid

from

 (select b.gid2 as pcgid, b.gid1 as appgid, a.gid1 as gid1, a.gid2 as gid2

 from 

  id_graph_positive_sample a

  right outer join

  id_graph_uniq b

  on a.gid1=b.gid2 and a.gid2=b.gid1

 ) c

 where c.gid1 is null and c.gid2 is null;