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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 15 Sep 1999 10:53:34 +0100
Message-ID: <937389439.25108.0.nnrp-14.9e984b29@news.demon.co.uk>

Go to the thread 'Insane Error', where I've posted an object-based solution.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

tomklaasen_at_my-deja.com wrote in message <7rnmr7$1lt$1_at_nnrp1.deja.com>...
>In article <w=fcN=FmlVwc06QOIGKS7mjGOA5h_at_4ax.com>,
> tkyte_at_us.oracle.com wrote:
>> 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....?
>> >
Received on Wed Sep 15 1999 - 04:53:34 CDT