Re: inner join in Oracle

From: Fergus Gallagher <Fergus.Gallagher_at_orbis-tech.co.uk>
Date: Wed, 16 Sep 1998 18:51:07 +0100
Message-ID: <35FFFA8B.C6CB93DE@orbis-tech.co.uk>

Use the syntax

WHERE
col1 (+) = col2

Bizarre but true. This is less flexible than the LEFT JOIN syntax, but easier to understand.

Fergus

Kevin Kirkpatrick wrote:
>
> I created an inner join SQL statement in access but I noticed that the
> statement will not work in oracle. Is there a particular way oracle
> does this type of a join? I am going to explore other ways around it
> for now, since there may be numerous ways of writing the same query.
> Thanks
>
> Kevin

--
Fergus Gallagher
Orbis Technology Ltd, UK Received on Wed Sep 16 1998 - 12:51:07 CDT