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