How do I build a query that will:
1 - check for duplicates based this criteria: first name AND last name AND email address (not OR, all three of those fields exact matches)
2- automatically merge duplicate records (records with all three fields matching exactly)
3- code records with one or two records matching (so those can be manually checked and merged if determined by human to be duplicates
Any help appreciated!