Assistance finding members with no claims
Posted on 2013-05-15
My thanks in advance for your assistance...
Code-wise, I am having a hard time with my SQL trying to figure out who has never had a claim for a certain time period yet is a member during the same time period.
It is easy for those with any claims between start_dt and end_dt but to state having a count of zero or NULL claims I realize is not logical.
The basic tables I am working with are MEMBERS and MASTER_CLAIM and maybe need to pull in a membership view vmembership.
I can provide some basic column names and data -- at this point I need more help jump-starting how to tackle the process!