DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OJ syntax for multi-table left outer join with MS Oracle Driver

121685Feb 25 2002

I have a multi-table left outer join that works fine in SQL Server ODBC Driver, Oracle ODBC driver 8.01.07.00, but not with Microsoft ODBC Driver for Oracle 2.573.7326.0

SELECT * from { oj A LEFT OUTER JOIN B ON A.col1 = B.col1 LEFT OUTER JOIN C ON A.col1 = C.col1 }

I noticed someone had a similar problem (the proposed solution doesn't work):
http://www.justpbinfo.com/listarchive/msg02874.html

Does anyone know how to get this working with the Microsoft ODBC Driver for Oracle? Or does it just not work?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2002

Added on Feb 25 2002

#odbc, #windows-and-net

3 comments

1,707 views