Thanks very much to all who have replied. This hornet's nest of a database that I've inherited has every conceivable worst practice. Nested view joining is just one of the many....but it's "character building", I suppose.

Thanks again --