Hi, I need to use ORDER BY clause in a UNION query and the Order BY columns are not included in the SELECT statement. I tried like this
(select .... from a) UNION (select ..... from b) order by a.ename;
It says that ERROR: Attribute "ename" not found
How to do this.
The "order by" is applying to the results of the union, not one of the sub-selects. If you want to sort by a value, you'll need to include it in the results list.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
