Re: LEFT JOIN ON INNER JOIN using Oracle 8i

Create the BC part using an in-line view and then join A to that.

Daniel Morgan

Donnchadh Ó Donnabháin wrote:

> Hi there,
> Could anyone explain how to do a left join on an inner join.
> I have three tables A,B,C. I want to do the following using
> the oracle syntax:
> SELECT * FROM A LEFT OUTER JOIN
> (B INNER JOIN C ON B.FKC = C.PKC AND C.FIELDA 'somevalue')
> ON A.PKA = B.FKA
>
> This doesn't work:
> SELECT * FROM A, B, C
> WHERE
> C.PKC = B.FKC
> AND A.PKA = B.FKA(+)
> AND C.FIELDA='somevalue'
>
> Donnchadh
Received on Mon Mar 04 2002 - 12:24:38 CST