Re: Help : Order by with Union clause

The answer if very simply. Noting that in a union you have no exact reference to a particular column since the unioned SQL's could in fact be entirely different tables/queries but the only requirement is that the TYPES of the columns be consistent with the SQL/UNION by position. Thus, the ANSI standard allows for ordering by position ONLY and not column name. This is optional in a simply query.

When is doubt check out the manual under UNIONS.

Marc Marchioli
The DataBase Group, Inc.
http://www.databasegroup.com

Suman Mehta wrote:
>
> Can we write an Order by Clause at the end of a select statement
> having the Union clause in it ?
>
> My SQL query (which has a union clause) works fine without
> it but gives an error message when I try to order by
> one of the columns.
>
> How do we overcome this problem ?
>
> ----------------------------------------------
> Suman Mehta
> E-mail ID : sumanp_at_yardi.com
Received on Wed Oct 15 1997 - 00:00:00 CDT