34,838
社区成员




select distinct s,e,aa,bb,cc from hh where checksum(s,e,aa,bb,cc) not int (select checksum(s,e,aa,bb,cc) from gg)
select distinct s,e,aa,bb from hh where checksum(s,e,aa,bb) not in(select checksum(s,e,aa,bb) from gg)
或
select
distinct s,e,aa,bb,cc
from
hh
where
not exists (select 1 from gg where s=hh.s and e=hh.e and aa=hh.aa and bb=hh.bb and cc=hh.cc)
select
distinct s,e,aa,bb,cc
from
hh
where
not exists (select 1 from gg where s=hh.s and e=hh.e and aa=hh.aa and bb=hh.bb)
select * from hh where checksum(s,e,aa,bb,cc) not in(select checksum(s,e,aa,bb,cc) from gg)
select * from hh where checksum(s,e,aa,bb) not in(select checksum(s,e,aa,bb) from gg)