I'm trying to create a new database diagram in SQL Server so that I can refer to it for relationships and that sort of thing. I opened SQL Server Enterprise Manager, created a new diagram, added ...

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