Oracle using Left Joins...

I have an SQL statement that works fine in dBase and Access, but for some reason Oracle doesn't like it. The reference books I have don't talk much about Left joins exept that they use a (+) instead of the word join. Is there some mode that Oracle is in that it's not interpreting this statement correctly?

If I remove the join and leave all the aliasing in the statement it works fine. In can use all fields from either table in a seperate select statement and it works ok. The error message I get is:

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