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

The query seems to work in Oracle 8.1.5:

SQL> create table t1 (a number);

Table created.

SQL> insert into t1 values (1);

1 row created.

SQL> insert into t1 values (2);

1 row created.

SQL> create table t4 (b number, c number);

Table created.

SQL> insert into t4 values (5,4);

1 row created.

SQL> insert into t4 values (3,3);

1 row created.

SQL> insert into t4 values (1,1);

1 row created.

SQL>
SQL> select t1.a, t2.b, t2.c
  2 from t1, (select b,c from t4 order by b) t2;

        A B C
--------- --------- ---------

        1         1         1
        2         1         1
        1         3         3
        2         3         3
        1         5         4
        2         5         4

6 rows selected.

Frank Hubeny

Harlin Setiadarma 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...
Received on Mon Sep 13 1999 - 23:10:36 CDT