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

I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.