Re: LEFT JOIN in oracle

From: XelA <asilic_at_net.hr>
Date: Fri, 4 Apr 2003 12:08:18 +0200
Message-ID: <b6jlii$l78$1@sunce.iskon.hr>

"Eirik Eldorsen" <eirikNOSPAM_at_eldorsens.nettsider.no> wrote in message news:b6jl5k$bc7$3_at_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
>

SELECT b.*, p.*
FROM Branch b, PropertyForRent p
WHERE b.bCity = p.pCity(+);

Here it is...

Best regards...

XelA Received on Fri Apr 04 2003 - 04:08:18 CST