Thanks Carl for your substantial reply.

I didn't consider using the group by subquery in the join. It is more difficult to for me to read and understand but I suppose...

Thanks for the help Carl.

Will check out the necessary etiquette for next time.

I can't believe that you so seldom have found the need to use a temp table or table variable. Being...