Selecting from a view that referred to a Select statement with right outer join gave wrong results
Selecting from a view that referred to a Select statement that had a right outer join returned incorrect results. The logic has been modified to fix this problem.