Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: select ... from (select ... from ... order by ...) doesn't work ?
I don't think that you are allowed to do an order by within a sub-select, or
within a view, but then I have to ask: Why would you want to? The only
order by that is going to count for anything is the one on the eventual
result set. Neither I nor my colleagues can see any value in being able to
do what you desire here.
Rod J. Stewart
Harlin Setiadarma <harlins_at_bigfoot.com> wrote in message
news:37dd0abd.0_at_news.cbn.net.id...
> Hi,
> I've tried to :
>
> select t1.a, t2.b, t2.c
> from t1, (select b,c from t4 order by b) t2
>
> and it give error message like syntax error ???
> But if I remove 'order by b' clause, it works....?
>
> Is somebody know how to make it works without removing order by clause ?
>
> Thanks in advance...
>
>
>
>
Received on Sun Sep 12 1999 - 23:12:28 CDT