Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Outer join

Re: Outer join

From: Marc <langkamp_at_mailcity.com>
Date: Wed, 16 May 2001 16:17:02 +0200
Message-ID: <3b028bdc$1@gaspra.oss.akzonobel.nl>

You might want to try this:

select....
where A.cd_a (+) = B.cd_b
UNION ALL
select....
where A.cd_a = B.cd_b (+)

"Diabolik" <Diabolik_at_Ginko.fr> wrote in message news:9dtlm4$cv0$1_at_pinco.nettuno.it...
> 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 - 09:17:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US