Ann W. Harrison wrote:

>
> Yes. That's what the optimizer attempts to do. However, it
> does not do the transformations necessary to convert a subquery
> to a join - transformations that become quite complex when the
> subquery can return a null set.

I should probably have mentioned that it can't change the order
of outer joins either.


Regards,


Ann