Re: Nested joins and ODBC

No you don't. What you need to do is get an Oracle book, open it, and read it.

I work in Redmond, WA. Many of my friends work for Microsoft. But I have to confess I am getting sick and tired of the MS mentality which is that whatever way I did it in a Microsoft product is the way it works and anything else is the work of a medieval demon or worse. Get over it. Quickly!

If you are going to work in Oracle the first thing you need to learn is that it is not a Microsoft product. It does not work like a Microsoft product. It is not supposed to work like a Microsoft product. And if Larry doesn't lose his mind it never will. The syntax is different, the architecture is different, transactions are different, data integrity is different, locking is different, and the very basis of the system is multiversioning which SQL Server doesn't have.

So unless you have some over-riding desire to make a huge ugly mess and then blame it on Oracle get a book and read it. The problems with Oracle will not be the software. If you make an insecure, unscalable, lousy performing home to corrupt data put the blame squarely where it belongs ... on yourself.

Back to your question: Can it be done? Of course. But only by people who learn how!

Daniel Morgan

Silvio Bierman wrote:

> Hello,
>
> I am porting a SQLServer app to Oracle 8 (using Oracle ODBC-driver) and I
> have stumbled onto a problem.
>
> I need to join three tables together using the join syntax:
>
> select * from a left outer join b on a.x=b.y left outer join c on b.i=c.j
>
> When I join only two tables I can use
>
> select * from {oj a left outer join b on a.x=b.y}
>
> but this does not work when joining more than two tables.
>
> Can this be done?
>
> Because the app needs to run on SQLServer also I can not use the Oracle
> outer join syntax!
>
> Regards,
>
> Silvio Bierman
Received on Fri Apr 05 2002 - 18:10:38 CST