select aa.a,nvl(b,0),nvl(c,0),nvl(d,0),nvl(e,0) from aa,bb where aa.a=bb.a(+)
union select bb.a,nvl(b,0),nvl(c,0),nvl(d,0),nvl(e,0) from aa,bb where aa.a(+)=bb.a;
union select bb.a,nvl(b,0),nvl(c,0),nvl(d,0),nvl(e,0) from aa,bb where aa.a(+)=bb.a;
就可以改了^_^,小心破产