SELECT A.COL1,A.COL2,A.COL3,A.COL4,B.COL5 FROM A,B WHERE A.COL1=B.COL1 AND A.COL2=B.COL2 AND A.COL3=B.COL3
SELECT A.COL1,A.COL2,A.COL3,A.COL4,B.COL5 FROM A,B WHERE A.COL1||A.COL2||A.COL3=B.COL1||B.COL2||B.COL3(+)union SELECT B.COL1,B.COL2,B.COL3,A.COL4,A.COL5 FROM A,B WHERE A.COL1||A.COL2||A.COL3(+)=B.COL1||B.COL2||B.COL3
SELECT A.COL1,A.COL2,A.COL3,A.COL4,B.COL5 FROM A FULL JOIN B ON ( A.COL1=B.COL1 AND A.COL2=B.COL2 AND A.COL3=B.COL3)
FROM A,B
WHERE A.COL1=B.COL1
AND A.COL2=B.COL2
AND A.COL3=B.COL3
FROM A,B
WHERE A.COL1||A.COL2||A.COL3=B.COL1||B.COL2||B.COL3(+)union SELECT B.COL1,B.COL2,B.COL3,A.COL4,A.COL5
FROM A,B
WHERE A.COL1||A.COL2||A.COL3(+)=B.COL1||B.COL2||B.COL3
FROM A FULL JOIN B ON ( A.COL1=B.COL1 AND A.COL2=B.COL2 AND A.COL3=B.COL3)