Re: URGENT PROBLEM PLEASE SOLVE IN SELECT STMT

I don't know what the cause of the problem is, but the following sql stmt
should provide a work around :

 select clli_org, trk_org, node_org
from (
select clli_org, trk_org, node_org

    from trunklis
    where trk_date='23-aug-98'
    minus
   select clli_org,trk_org,node_org
   from trunklis
   where trk_date='16-aug-98')
order by node_org;

Sreenivas wrote:

> Hi,
>
> I used the following query as cursor in creating a package body:
>
> select clli_org, trk_org, node_org
> from trunklis
> where trk_date='23-aug-98'
> minus
> select clli_org,trk_org,node_org
> from trunklis
> where trk_date='16-aug-98'
> order by node_org;
>
> it is giving the following error:
> order by item must be in Select-list expression.
>
> If i run the same query at SQL prompt, it is working fine.
>
> Can any one tell me What is the possible reason for this?
Received on Fri Aug 28 1998 - 09:44:48 CDT