Re: select ... from (select ... from ... order by ...) alias doesn't work ?

You can not use ORDER BY in view or subquery. Try
 select t1.a, t2.b, t2.c
 from t1, (select distinct b,c from t4 ) t2

or

 select t1.a, t2.b, t2.c
 from t1, (select b,c from t4 ) t2
 order by t2.b

Mark

Harlin Setiadarma <harlins_at_bigfoot.com> wrote in message news:37dd0afd.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:29:30 CDT