Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL question
>
> Agreed. All I was trying to do was use the OP's original query and
> show where it was lacking. I wasn't trying to suggest that mine was a
> particularly good way of doing it. The reference to the appalling
> execution plan was intended to be the clue!
>
> I think the fundamental issue here was the assumption (or desire) that
> an outer join would show only the non-matched rows.
>
Sorry for not recognizing the hint of sarcasm. I knew that you know better.
-- What lies behind us and what lies before us are small matters when compared to what lies within us. Wolfgang Breitling Oracle 7, 8, 8i, 9i OCPReceived on Wed Nov 05 2003 - 00:19:59 CST