Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> LEFT JOIN ON INNER JOIN using Oracle 8i
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 - 09:17:49 CST
![]() |
![]() |