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]
