Outer Joins

USoft Developer supports the use of Oracle (8i or earlier) outer join syntax, using the (+) notation. Outer joins can be nested and non-nested.

On all other database servers, this outer join syntax using (+) is translated to ANSI 92/ODBC outer join syntax.

Exceptions:

Outer joins cannot be used in combination with the RELATE keyword, and cannot be used on component tables.

USoft versus ANSI 92/ODBC Outer Join syntax

USoft Syntax

ANSI 92/ODBC Syntax

SELECT *

FROM t1, t2

WHERE t1.col1 = t2.col1(+)

SELECT *

FROM t1 LEFT OUTER JOIN t2

ON t1.col1 = t2.col1

SELECT *

FROM t1, t2, t3

WHERE t1.col1 = t2.col1(+)

AND t2.col1 = t3.col1(+)

SELECT *

FROM t1 LEFT OUTER JOIN t2

ON t1.col1 = t2.col1 LEFT OUTER JOIN t3

ON t2.col1 = t3.col1