select * from SP_KY_VIEW_YX_YYXXGJCLDY
minus
select * from SP_KY_VIEW_YX_YYXXGJCLDY
where (hphm,hpzl,hpdqbm) in(select hphm,hpzl,hpdqbm from SP_KY_VIEW_YX_YYXXBX)hphm,hpzl,hpdqbm要是索引.
试试
minus
select * from SP_KY_VIEW_YX_YYXXGJCLDY
where (hphm,hpzl,hpdqbm) in(select hphm,hpzl,hpdqbm from SP_KY_VIEW_YX_YYXXBX)hphm,hpzl,hpdqbm要是索引.
试试
from SP_KY_VIEW_YX_YYXXGJCLDY a,SP_KY_VIEW_YX_YYXXBX b
where not (a.hphm=b.hphm
and a.hpzl=b.hpzl
and a.hpdqbm=b.hpdqbm)
试试
谢谢,比我的快多了