UNION provides an implicit unique sort. use UNION ALL if you don't want that.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote