constructing a select and excluding duplicates

[Rob Kudyba]

I am trying to construct a SELECT statement on distinct email addresses. 
Our DB has emails entered by various sources and there are duplicate 
addresses based on the source. Using sample table names and sources here 
is what I have:

SELECT  DISTINCT email_address
FROM  'email_table'
WHERE SOURCE =  'source 1'
Simple enough, but I want to exclude email addresses that appear in 
several other sources, i.e, something like in this pseudo sample:

SELECT  DISTINCT email_address
FROM  [ENTIRE_TABLE_IN_DATABASE]
WHERE SOURCE =  'source 1'
AND EXCLUDE email_address IF SOURCE = [source 2, source 4, source 6]
Thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]