I have created a fairly complex view based upon several UNION statements and the view selects exactly the rows that I want if I am in ORACLE SQLPLUS or MS Access. But in Crystal Reports it returns rows that should not be visible through this view. Has anyone else experienced this and what did you to get around this?