I am extracting rows which then form part of an email using a scheduled background job (Java). I have excluded archived members in the SQL; however, I am told that accounts are still receiving emails relating to archived members.
My extract SQL is:
I have run this against the production data and the result did not include any archived members. An account holder has forwarded an email to me that shows an archived member.