2 Replies Latest reply: Jan 16, 2013 2:03 AM by 984640 RSS

    ORA-01417:a table may be outer joined to at most one other table

    984640
      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:
      SELECT *
      FROM B, A, C, D, J, K, L, E, F, G, H, I
      WHERE B.COL1='ABC'
      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'

      Kindly advise.
      Thanks in advance!