Re: Newbie - SQL

Try this :

SQL> select T1.* , T2.* from table_1 T1, table T2 where T1.id = T2.id ;

reagrds ,

TA.

"Addison Schildt" <as8123_at_yahoo.com> a écrit dans le message news: a8aaij$7q0$1_at_slb3.atl.mindspring.net...
> Learning with Oracle 8i (UNIX). The SQL below gives
>
> ORA-00933: SQL command not properly ended
>
> SELECT Table1.*, Table2.*
> FROM Table1 INNER JOIN Table2 ON Table1.ID = TABLE2.ID;
>
> What have I done wrong? Thanks in advance.
>
>
Received on Mon Apr 01 2002 - 11:45:06 CST