Sorry for the initial messy post.

I think you guys are right. I have tried writing the view without joins and the result set is never the same. I will look at indexing the tables.

Thanks!