Apologies. The view used to be a simple reference to the base table. It has been changed since I last looked at it. Seems I was making it more complicated than required. Those tables ARE in the view. :rolleyes:

So Gail, NOLOCK, what's the problem with that ?