I am having an issue about sending emails to only those clients that are added to subscription services. Since I may have the same client at different recipient folders, I want to exclude her/him entirely from my deliveries if she/he did, within a recipient folder, have opted out from subscription services.
I know that usually subscription services are connected to a client ID and not email for example. Therefore, if I have the same client in different folders, the same client will have a different ID in each one. How can I reconcile the data to only consider, from the results of these two queries, the same client (by email) that appears on both subscription lists for the two folders it appears?