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

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 - 19:31:25 CDT