LEFT JOIN in oracle
From: Eirik Eldorsen <eirikNOSPAM_at_eldorsens.nettsider.no>
Date: Fri, 04 Apr 2003 12:03:19 +0200
Message-ID: <b6jl59$bc7$2_at_balder.stud.idb.hist.no>
[Quoted] What is the syntax for a LEFT JOIN in oracle?
Date: Fri, 04 Apr 2003 12:03:19 +0200
Message-ID: <b6jl59$bc7$2_at_balder.stud.idb.hist.no>
[Quoted] 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 - 12:03:19 CEST