Below is an example of my membership table. There some records having multiple values in the email field. I only want to select those records that have multiple email values:
ID LASTNAME FIRSTNAME EMAIL 567 Jones Carol firstname.lastname@example.org 567 Jones Carol email@example.com 678 Black Ted firstname.lastname@example.org 908 Roberts Cole email@example.com 908 Roberts Cole firstname.lastname@example.org 908 Roberts Cole email@example.com
I would like the result to be:
567 Jones Carol firstname.lastname@example.org 567 Jones Carol email@example.com 908 Roberts Cole firstname.lastname@example.org 908 Roberts Cole email@example.com 908 Roberts Cole firstname.lastname@example.org
Notice that Ted Black is missing because he only has one entry for email address.
I should clarify that my membership table has more than 4 columns. There are additional columns for phone and address, etc. And there could be multiple entries for a member because he/she has more than one phone number or address. I only want to capture those individuals who have multiple email addresses.
This is part of a database cleanup and a primary key will be added. I should clarify further that some persons could have multiple entries with same email address. At this phase I don't want to capture those multiple entries with the same email address but only those have who multiple entries with different email address.