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
Your book is probably out of date. With ORACLE 9i, you can use LEFT
JOIN (or LEFT OUTER JOIN) syntax. ORACLE 9i supports NATURAL JOIN,
FULL OUTER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN.
Received on Fri Apr 04 2003 - 12:23:33 CST
