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

Home -> Community -> Usenet -> c.d.o.misc -> LEFT JOIN ON INNER JOIN using Oracle 8i

LEFT JOIN ON INNER JOIN using Oracle 8i

From: Donnchadh Ó Donnabháin <donnchadh_at_computer.org>
Date: 4 Mar 2002 07:17:49 -0800
Message-ID: <3697467c.0203040717.58c0b046@posting.google.com>


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

Original text of this message

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