Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: select ... from (select ... from ... order by ...) alias doesn't work ?

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

From: John Chiu <johnymc_at_netscape.com>
Date: Mon, 13 Sep 1999 06:41:21 -0400
Message-ID: <37DCD4D1.EF2F7E7B@netscape.com> 





It is just a matter of the sytax of your select statement.



You can try



select t1.a, t2.b, t2.c


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



John Chiu


johnymc_at_netscape.net

Received on Mon Sep 13 1999 - 05:41:21 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US