Greetings! I want to GROUP BY and ORDER BY on the result of UNION similar to the following (wrong) SQL:
(SELECT c11 AS c1,SUM(c12) AS c2 FROM table1 UNION SELECT c21 AS c1,SUM(c22) AS c2 FROM table2 ) GROUP BY c1 ORDER BY c2; Please note that the following is NOT what I want because it generates 2 groups of data set: SELECT c11 AS c1,SUM(c12) AS c2 FROM table1 GROUP BY c1 ORDER BY c2 UNION SELECT c21 AS c1,SUM(c22) AS c2 FROM table2 GROUP BY c1 ORDER BY c2; How do I do that? Thank you in advance! CNLIOU ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
