Grouping an Union query [Oracle]
Posted on 2010-01-11
I'm working on a query that looks (more or less) like this:
category, software, user_PC
FROM categories, softwares, users
GROUP BY category, software, user
category, software, PC
FROM categories, softwares, PCs
GROUP BY category, software, PC
but what I get as result is something like:
Graphic - Photoshop - John Smith
Graphic - Photoshop - Jack Russel
Microsoft - Office Word - Usain Bolt
Microsoft - Office Excel - Mister Mint
Graphic - Photoshop - Additional_PC
Graphic - Corel Draw - Unknown_PC
As you can see, the first and the second part of the query are grouped separately (first, all of users, and then, all of PCs). But what I hope to get is the group "Graphic" for both users and PCs, then the group Microsoft, and so on...
How can I do it?
Any help is really appreciated. Thank you in advance!