I have a simple report query below. What is happening is that it is reporting on clients that don't exist in those policies any longer. I'm sure this is historical but how would you tweak the query to only pull clients that are currently in a policy, I don't see any timestamp data on this particular table.
There may be a canned report that will provide this info, but the idea is delve into the schema objects directly for a better understanding and how to generate weird reports.
WHERE upper(policyName) not in ...
thanks in advance