help with select distinct

[richie]

Hi,

I need to select 3 columns from a database, but I only want columns with the same email address selected once.

I know I could do this:

SELECT DISTINCT email FROM mydb

This will do what I want. Unfortunately, when I add the other columns, like this,

SELECT DISTINCT email,source,id FROM mydb

duplicate email addresses are selected.

Is there a way to select multiple columns and eliminate duplicates based only on a particular column?

Thx
Richie.

[jweissig]

hello,

try "SELECT DISTINCT email, source, id FROM mydb GROUP BY email"

this just groups all of the same e-mail addresses

thanks,
- justin