Query not returning all rows in the table
I have a report that queries a view (memberInfo) on a table (Member). It has been working fine until lately it not returning all rows that match a certain criteria.
For example, when I run the report to return all users who have a certain job title its not returning several users that I can verify are in the 'Members' table matching that criteria. I can run a select statement in SQLPlus and verify that the member matching the jobtitle criteria does infact exist.I exported the report and table to my test envirnment and it works fine there. Any help greatly appreciated, thanks!