|
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
|
|
