| Order By problem [message #88045] |
Thu, 24 January 2002 01:20  |
Rohan Rege
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
I am trying to customise an existing Oracle Report where in I got to add an sort on a field.
Here the query consists of Union of three Select statements on different views .
I tried putting the "order by <field_name> " clause
at the end of the query
i.e after putting the query in closed brackets,
But it gives the following error :
Order BY item must a number in the Select-list expression.
Please reply asp
|
|
|
|
| Re: Order By problem [message #88464 is a reply to message #88045] |
Wed, 18 September 2002 08:16  |
Aziz
Messages: 8
Registered: October 2001
|
Junior Member |
|
|
also select some coloums after union like
select a.col1,a.col2 from
(select col1,col2 from x
union
select col1,col2 from y
union
select col1,col2 from z) a
order by a.col1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
