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 -> Re: LEFT JOIN ON INNER JOIN using Oracle 8i

Re: LEFT JOIN ON INNER JOIN using Oracle 8i

From: Donnchadh Ó Donnabháin <donnchadh_at_computer.org>
Date: 5 Mar 2002 05:55:14 -0800
Message-ID: <3697467c.0203050555.36058b21@posting.google.com> 





damorgan <dan.morgan_at_ci.seattle.wa.us> wrote:


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




 Thanks. The following seems to work:


SELECT * FROM A, 



  (SELECT B.FKA, C.FIELDA FROM B, C 



      WHERE C.PKC = B.FKC AND C.FIELDA='somevalue') D 
WHERE A.PKA = D.FKA(+)


  Donnchadh
Received on Tue Mar 05 2002 - 07:55:14 CST












Original text of this message













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