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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 13 Sep 1999 09:10:45 -0400
Message-ID: <w=fcN=FmlVwc06QOIGKS7mjGOA5h@4ax.com>

A copy of this was sent to "Harlin Setiadarma" <harlins_at_bigfoot.com> (if that email address didn't require changing) On Mon, 13 Sep 1999 07:30:24 +0700, you wrote:

>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...
>
>
>

that syntax is supported in Oracle8i, release 8.1

It is not supported in any prior release.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 13 1999 - 08:10:45 CDT