SQL Query help please!!!!

wxdqz

New Member
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
 
Back
Top