Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.frii.net!newsfeed.frii.net!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!uninett.no!hist.no!not-for-mail
From: Eirik Eldorsen <eirikNOSPAM@eldorsens.nettsider.no>
Newsgroups: comp.databases.oracle.tools
Subject: LEFT JOIN in oracle
Date: Fri, 04 Apr 2003 12:03:19 +0200
Organization: HiST
Lines: 8
Message-ID: <b6jl59$bc7$2@balder.stud.idb.hist.no>
NNTP-Posting-Host: i1269.stud.idb.hist.no
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: balder.stud.idb.hist.no 1049450473 11655 158.38.54.114 (4 Apr 2003 10:01:13 GMT)
X-Complaints-To: usenet@balder.stud.idb.hist.no
NNTP-Posting-Date: Fri, 4 Apr 2003 10:01:13 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
Xref: newsfeed1.easynews.com comp.databases.oracle.tools:58079
X-Received-Date: Fri, 04 Apr 2003 03:00:45 MST (news.easynews.com)

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