Re: SQL*plus: join operator error

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 30 Apr 2002 09:44:59 +0200
Message-ID: <3CCE4B7B.7060705@mytoys.de>

Sted Alana wrote:

>>Sorry to say so: YES. In 8i you have to use classical Oracle join syntax
>>

> like
>

>>(+) for outer join etc.
>>

>
> can you point me to the syntax for classical join syntax so i can use it on
> my assignment.
>
> I dont like to use inner queries to join multiple tables - less readable.

Look at

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/expressi.htm#1023206

and scroll up and down to read more about joins.

Regards,

Knut Received on Tue Apr 30 2002 - 02:44:59 CDT