Ok experts, I need some serious help with this one.
Basically I have a table and a query. When run the query gets looks up a username in the table, goes to another table, looks up an email addy (using the username) then sends an email to the address.
What I would like to do is eliminate duplicate entries, so each person only gets one email.
So far I have it working fine, but each person receives an email for each time they are listed in the original table.
Is there a way to do
retrieve only 1 record per username? in SQL?
Thanks in advance!
Alicia
xxx
Basically I have a table and a query. When run the query gets looks up a username in the table, goes to another table, looks up an email addy (using the username) then sends an email to the address.
What I would like to do is eliminate duplicate entries, so each person only gets one email.
So far I have it working fine, but each person receives an email for each time they are listed in the original table.
Is there a way to do
retrieve only 1 record per username? in SQL?
Thanks in advance!
Alicia
xxx