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@xxxxxxxxxxxx> 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. > -- //www.freelists.org/webpage/oracle-l