Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Outer join
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