Xref: alice comp.databases.oracle:73804
Date: Wed, 11 Nov 1998 22:16:15 +0100
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Newsreader: Virtual Access by Ashmount Research Ltd, http://www.ashmount.com
Message-ID: <VA.0000000c.00118611@ph2>
Subject: Re: Oracle using Left Joins...
From: Peter Hiemenz <PeterHiemenz@compuserve.com>
Reply-To: PeterHiemenz@compuserve.com
References: <36472D16.7A4E355B@jcn1.com>
Newsgroups: comp.databases.oracle
Path: alice!news-feed.fnsi.net!WCG!arl-news-svc-3.compuserve.com!news-master.compuserve.com!nntp-nih2naac.compuserve.com
Lines: 19

In article <36472D16.7A4E355B@jcn1.com>, Steve Meier wrote:
> LEFT JOIN Conducto C ON S.Conductor = C.Conductor WHERE
> S.SECTIONNUM <> '-1' OR S.SECTIONNUM = Null ORDER BY S.SectionNum,
> S.Piece
>

As far as I know, the keyword "left" only has any sense when used in an 
OUTER JOIN statement.


Peter


Peter Hiemenz
Hilden
Germany

PeterHiemenz@compuserve.com