Tom,
> I believe the sub-SELECT will only get executed once, since it has no
> dependency on the outer query.
That seems to be the behavior its exhibiting.
> What were you expecting to happen?
The clouds parting, choirs of angels singing, and fireworks
celebrating the veil of my obtuseness being lifted, and my grasp and
command of SQL to be complete and infinite. None of which appears
will ever happen...
-- Gary Chambers
/* Nothing fancy and nothing Microsoft! */