Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ORACLE 7.3 using ODBC and Left Outer Joins...
In a document from Oracle "Using The Oracle ODBC Drivers with Thrid Party
Products", the talk about Joins and the Oracle ODBC Driver. They state that
they support the JOIN operation in version 2.x of the driver. We are
running v2.05.0301. They go on to say that the only supported syntax is the
"ODBC JOIN Escape syntax", not Oracle syntax. Then give an example:
select dept.deptno, sum(sal) from {oj dept left outer join emp on dept.deptno = emp.delpno} group by dept.deptno
Here's the statement I'm using:
SELECT S.SECTIONNUM, S.UPSECTION, S.PIECE, S.SECT_TYPE, S.CONDUCTOR AS SectionConductor, S.PHASE, S.MAPNAME, C.CONDUCTOR AS ConductorConductor FROM {oj SECTIONS S LEFT OUTER JOIN CONDUCTO C ON S.CONDUCTOR = C.CONDUCTOR} WHERE S.SECTIONNUM <> '-1' OR S.SECTIONNUM IS Null ORDER BY S.SECTIONNUM, S.PIECE If I run it with the oj in the statement after the FROM {, I get the following error:
SQLSTATE: S1000
Native Error Code: 1719
Driver Message:[Oracle]ODBC Oracle Driver][Oracle OCI][ORA-01719: outer join
operator (+) not allows in operand of OR or IN.
If I don't include the oj when I run it I get a syntax error.
Anyone got any ideas on what the syntax for this is supposed to look like?
Any help would be greatly appreciated!
-Steve Received on Mon Apr 05 1999 - 15:22:42 CDT
![]() |
![]() |