Re: ORDER BY in a UNION Query

[Justin MacCarthy]

I would say  the issue is possibly a reserved word or a quotation mark....
 Can you output the SQL the is generated????


~Justin


> When I stick the Order By statement at the end of the second Select
clause,
> Oracle returns the error:
> "[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904: invalid column name
"
>
> The column names Name and Reason *are* present in both tables. I tried to


------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.