Hi, I'm using Oracle 8i and could not use LEFT JOIN. So I need to use (+) instead.
But I'm encountering ORA-01417 for I.COL3 (+) =G.COL5
The complete command as follows:
FROM B, A, C, D, J, K, L, E, F, G, H, I
AND B.COL1=A.COL1 AND B.COL2=A.COL2 AND B.COL3=A.COL3
AND C.COL1=B.COL1 AND C.COL2=B.COL6 AND C.COL3=B.COL7
AND B.COL1=D.COL1 (+) AND D.COL2 (+) =B.COL6
AND A.COL1=J.COL1 (+) AND A.COL2=J.COL2 (+)
AND B.COL1=K.COL1 (+) AND B.COL6=K.COL2 (+) AND B.COL11=K.COL3 (+) AND B.COL12=K.COL4 (+)
AND A.COL1=L.COL1 (+) AND A.COL2=L.COL2 (+) AND A.COL3=L.COL3 (+)
AND E.COL1 (+) = 'ABC' AND E.COL2 (+) =C.COL20 AND E.COL3 (+) =C.COL21
AND F.COL1 (+) = 'ABC' AND F.COL2 (+) =C.COL20
AND G.COL1 (+) = 'ABC' AND G.COL2 (+) =B.COL11 AND G.COL3 (+) =B.COL12
AND H.COL1 (+) = 'ABC' AND H.COL2 (+) ='NIP' AND H.COL3 (+) =G.COL5
AND I.COL1 (+) = 'ABC' AND I.COL2 (+) ='NIP' AND I.COL3 (+) =G.COL5* AND I.COL4 (+) =A.COL5 AND I.COL5 (+) ='0001'
Thanks in advance!
This is the forum for Oracle's SQL Developer tool, not for general SQL and PL/SQL questions. Questions like this will get a better response in the SQL and PL/SQL forum.
Having said that, this is a limitation of oracle's older outer join syntax. Outer joins can be rewritten using UNION and (apart from upgrading to a more recent version of oracle) that is probably your only option.