Re: LEFT JOIN in oracle

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 4 Apr 2003 08:39:48 -0800
Message-ID: <1b061893.0304040839.462acf12@posting.google.com>

This is going to work in Oracle 9i, but not in any version before this. Try to read some books in sync with your database version.

Daniel

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
Received on Fri Apr 04 2003 - 10:39:48 CST