select t1.a,t1.b,t2.a,t2.b from t1,t2 where t1.a=t2.a(+) and t1.b=t2.b(+) union select t1.a,t1.b,t2.a,t2.b from t1,t2 where t1.a(+)=t2.a and t1.b(+)=t2.b
select t1.A, t1.B, t2.A, t2.B from ( select A from t1 union select A from t2 )t, t1, t2 where t.A=t1.A(+) and t.A=t2.A(+)
select t1.a,t1.b,t2.a,t2.b
from t1,t2
where t1.a=t2.a(+)
and t1.b=t2.b(+)
union
select t1.a,t1.b,t2.a,t2.b
from t1,t2
where t1.a(+)=t2.a
and t1.b(+)=t2.b
from
(
select A from t1
union
select A from t2
)t, t1, t2
where t.A=t1.A(+) and t.A=t2.A(+)