Hi,

I have the a table (subscribers) where the key columns here are subscriberid, email, firstname, lastname. e.g.

subriberid email firstname surname
---------------------------------------------------
01 [email protected] alan smith
02 [email protected] brian jones
03 [email protected] chris woods
04 [email protected] alan smith

If I use "select distinct email from subscribers" I get:

email
-----
[email protected]
[email protected]
[email protected]

But what query would I use to return *all* data but where the email is unique? i.e.

subriberid email firstname surname
---------------------------------------------------
01 [email protected] alan smith
02 [email protected] brian jones
03 [email protected] chris woods

Thanks for your help.

Ronnie

What happens if you also had a row like:

05 [email protected] john doe

which row is the 'correct" one for email address [email protected]?


Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

I've had a look at the data and the duplicate emails contain duplicate information throughout.