Oracle using Left Joins...
From: Steve Meier <sdmeier_at_jcn1.com>
Date: Mon, 09 Nov 1998 11:57:42 -0600
Message-ID: <36472D16.7A4E355B_at_jcn1.com>
Greetings,
Date: Mon, 09 Nov 1998 11:57:42 -0600
Message-ID: <36472D16.7A4E355B_at_jcn1.com>
Greetings,
37000: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00933: SQL command not properly ended.
Oracle is running on NT Server.
SELECT S.SectionNum, S.UpSection, S.Piece, S.SECT_TYPE, S.CONDUCTOR AS SectionConductor, S.Phase, S.MapName, C.Conductor AS ConductorConductor FROM SECTIONS S LEFT JOIN Conducto C ON S.Conductor = C.Conductor WHERE S.SECTIONNUM <> '-1' OR S.SECTIONNUM = Null ORDER BY S.SectionNum, S.Piece
Anyone have any ideas?
Thanks,
-Steve Received on Mon Nov 09 1998 - 18:57:42 CET