Great information everyone. That is why I love coming here. Thanks for all your help!

Thanks for the reply. I was concerned that the View would create the virutal table and populate with all the data prior to executing my query. The view...

This is a late update but the problem was with nulls.  Thank you.