Re: Using the + statement in a Select statement

I only noticed this posting today, so I apologize for not responding sooner.

Try re-writing this using the (+) notation:

SELECT <something>
FROM (a LEFT JOIN b ON a.f1=b.f1)

        LEFT JOIN c ON c.f2=b.f2

It is possible, and not that hard, but absolutely unnatural as it turns the query upside down

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E5FD2D9.F4FEE0D8_at_exesolutions.com...
> ANSI joins are no more powerful and ambiguity is in the eyes of the
beholder.
> .........
> While I know and teach the ANSI syntax. I learned Oracle more than 10
years ago
> and would only write it if I had a compelling reason to do so.
Received on Tue Mar 11 2003 - 19:00:35 CST