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

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...