Thank you once again, Paul. I'll be experimenting today.

I just noticed something that I think is in error:

The first CROSS JOIN example under your "Equivalent Expressions Using APPLY and JOIN" header performs "ORDER BY S.name ASC, S.name ASC". Is that supposed to be "S.name ASC, J.name ASC"?

Regards,

Mike M