create proc procname as select t1.wlmc,t1.wlsl,t1.bz,t2.wlmc as t2_wlmc,t2.wlsl as t2_wlsl,t2.bz a t2_bz from t1 left join t2 on t1.dh=t2.dh where t1.wlmc<>t2.wlmc or t1.wlsl<>t2.wlsl or t1.bz<>t2.bz
用 select a.wlmc,a.wlsl,a.bz,b.wlmc,b.wlsl,b.bz from t1 a, t2 b where a.dh=b.dh and (a.wlmc <> b.wlmc Or a.wlsl <> b.wlsl Or a.bz <> b.bz) 或 select a.wlmc,a.wlsl,a.bz,b.wlmc,b.wlsl,b.bz from t1 a, t2 b where a.dh=b.dh and a.dh not in (select a.dh from u1 a, u2 b where a.dh=b.dh and a.wlmc=b.wlmc and a.wlsl=b.wlsl and a.bz=b.bz)
select t1.wlmc,t1.wlsl,t1.bz,t2.wlmc as t2_wlmc,t2.wlsl as t2_wlsl,t2.bz a t2_bz
from t1 left join t2
on t1.dh=t2.dh where t1.wlmc<>t2.wlmc or t1.wlsl<>t2.wlsl or
t1.bz<>t2.bz
select a.wlmc,a.wlsl,a.bz,b.wlmc,b.wlsl,b.bz
from t1 a, t2 b
where a.dh=b.dh and (a.wlmc <> b.wlmc Or a.wlsl <> b.wlsl Or a.bz <> b.bz)
或
select a.wlmc,a.wlsl,a.bz,b.wlmc,b.wlsl,b.bz
from t1 a, t2 b
where a.dh=b.dh and
a.dh not in (select a.dh
from u1 a, u2 b
where a.dh=b.dh and a.wlmc=b.wlmc and a.wlsl=b.wlsl and a.bz=b.bz)