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

Developers can also ask the assistant to explain SQL code, such as what is the difference between a join and a left outer join, Hichwa said. The assistant can also be accessed via the SQL Workshop ...