Hi, I hope someone can assist.
I have a table with the following fields: Contact_ID, Company_ID and EmailAddress.
The situation is that the same email address can be associated with 1 or more companies.
Therefore the Contact_ID and Company_ID will differ from the same email address.
For example
Contact_ID Company_ID EmailAddress
1212 456 Joe@example.com
1453 597 Joe@example.com
6236 456 Fred@example.com
7235 839 Joe@example.com
I would like to design a query that shows only 1 distinct Joe@example.com email address, associated with either the lowest or highest Contact_ID (I do not have a preference)
So the result may be:
Contact_ID Company_ID EmailAddress
1212 456 Joe@example.com
6236 456 Fred@example.com
Is this possible?
Thanks!
I have a table with the following fields: Contact_ID, Company_ID and EmailAddress.
The situation is that the same email address can be associated with 1 or more companies.
Therefore the Contact_ID and Company_ID will differ from the same email address.
For example
Contact_ID Company_ID EmailAddress
1212 456 Joe@example.com
1453 597 Joe@example.com
6236 456 Fred@example.com
7235 839 Joe@example.com
I would like to design a query that shows only 1 distinct Joe@example.com email address, associated with either the lowest or highest Contact_ID (I do not have a preference)
So the result may be:
Contact_ID Company_ID EmailAddress
1212 456 Joe@example.com
6236 456 Fred@example.com
Is this possible?
Thanks!