I need to form the equivalent of a Union Join in Oracle 8i, even though a Union Join doesn't appear to be supported in 8i. I might be able to manipulate a Full Outer Join to get the results I need ...

A right outer join, specified with the keywords RIGHT JOIN and ON, has all the rows from the Cartesian product of the two tables for which the sql-expression is true, plus rows from the second ...

When you review your SQL code (by selecting Show SQL from the View menu), you see that DB2 SQL has used set operators (such as UNION) to produce an outer join result, instead of using outer join ...

In this SQL Server tip, Arthur Fuller explains the effects of NULLs, and the different results obtained by inner and outer JOINs.