So what are you really after: All email addresses that are unique (not multiple-sourced)? The email addresses from source1 that are duplicated from no other sources? The email addresses from source1 that are not from any of the following sources (source2, source4, or source6)? The email addresses from source1 that are also not part of all of the following sources (source2, source4, and source6)?
Often questions like this are posted because someone is trying to solve another problem and this is just an intermediate step. If that's your situation, there may be better ways of achieving your final result than going this route. What is it you eventually want to achieve with this list of email addresses? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Rob Kudyba <[EMAIL PROTECTED]> wrote on 11/04/2004 12:26:42 PM: > 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] >