Re: Outer join

you cannot do this.
the use of outer joins is specified when one column is lacking relative to the column you are joining to. The (+) going to the column lacking in data.

It isn't possible for both columns to fit this criteria at the same time during an outer join together.

On Wed, 16 May 2001 12:49:57 +0100, "Diabolik" <Diabolik_at_Ginko.fr> wrote:
>Suppose i've 2 tables A and B
>
>A
>---
>cd_A
>desc_a
>
>B
>--
>cd_b
>desc b
>
>I can do an uter join like this
>
>where A.cd_a = B.cd_b (+)
>
>or
>
>where A.cd_a (+) = B.cd_b
>
>Do exists a method to do the next:
>
>where A.cd_a (+) = B.cd_b (+)?
>
>
>
>
>
>
>
>
Received on Wed May 16 2001 - 07:04:53 CDT