Re: Oracle using Left Joins...

From: Peter Hiemenz <PeterHiemenz_at_compuserve.com>
Date: Wed, 11 Nov 1998 22:16:15 +0100
Message-ID: <VA.0000000c.00118611_at_ph2>

In article <36472D16.7A4E355B_at_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_at_compuserve.com Received on Wed Nov 11 1998 - 22:16:15 CET

This message: [ Message body ]
Next message: bonanos_at_yahoo.com: "Re: help Oracle Web Server - HTTPD upload problem"
Previous message: Dipesh R. Sheth: "Oracle 8 and Oracle forms 5.0 connection problem"
In reply to: Steve Meier: "Oracle using Left Joins..."
In reply to Steve Meier: "Oracle using Left Joins..."
Next in thread: bonanos_at_yahoo.com: "Re: help Oracle Web Server - HTTPD upload problem"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message