Background documentation-3022: A table may not be outer joined to at most one other table Locate this document in the navigation structure

 

Explanation

A JOIN predicate was specified with an OUTER JOIN indicator (+). Using this OUTER JOIN indicator you can desribe a LEFT OUTER JOIN only.

Example Example

SELECT ... FROM table_a, table_b, table_c

WHERE table_a.column_a = table_b.column_b(+)

AND table_c.column_c = table_b.column_b(+)

End of the example.
User Response

Change the SQL statement using ANSI syntax.

Example Example

SELECT ... FROM table_a

LEFT OUTER JOIN table_b ON table_a.column_a = table_b.column_b

RIGHT OUTER JOIN table_c ON table_c.column_c = table_b.column_b

End of the example.