You need to search AskTom for the "rownum" trick also. That would
likely work here since it forces the inner queries to resolve. I use
that one quite a bit. Sorry I don't have more time to test this.
On 3/2/06, Mike Schmitt <mschmitt_at_uchicago.edu> wrote:
>
> There have been a number of good ideas on how to rewrite the query. I plan
> to test them out later to help me learn. My query writing ability is
> probably a 0 out of 10.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 02 2006 - 17:08:01 CST
