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 in oracle

LEFT JOIN in oracle

From: Eirik Eldorsen <eirikNOSPAM_at_eldorsens.nettsider.no>
Date: Fri, 04 Apr 2003 12:03:30 +0200
Message-ID: <b6jl5k$bc7$3@balder.stud.idb.hist.no> 





What is the syntax for a LEFT JOIN in oracle?



In my database book this syntax is shown wihich is not for oracle:
SELECT b.*, p.*


FROM Branch b LEFT JOIN PropertyForRent p ON b.bCity = p.pCity



Eirik Eldorsen
Received on Fri Apr 04 2003 - 04:03:30 CST












Original text of this message













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