Re: Using the + statement in a Select statement

Isaac Blank wrote:
> 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
>

I forgot the symantics of the ANSI syntax, and it took a bit to find my reference book. But given your query, it was easy to write:

Select <something>
from (select * from A, B where a.f1=b.f1(+) ) BB, C where c.f2=bb.f2(+) ;

This looks interesting if it happened in real life. But I do not see the "upside down" query that you expected.

Or did I miss something stupid? 8^>

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost