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 not sure if that's the right term, but how do I list records that are <B>not</B> matched to records in another table? I am joining 2 tables right now, tblPerson and tblHat, which are designed and ...