Quote Originally Posted by brucevde
Is there a reason you are using 3 views. It seems your query would be a simple 3 table join, which would get you the data needed in the format you need.
I've looked at changing to just one view but I don't think this will be possible because each of my views already join several tables within them. I think if I tried to join all of them together it would produce incorrect results.