Try
select a.col1 as ename from a union select b.othercolumn as ename from b order by ename
Give the columns you want to order on the same name using the "as XXX" syntax, and remove the "a." prefix from the order statement.
John Sidney-Woollett
Antony Paul wrote:
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.
rgds Antony Paul
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
