Nope, You need a key on your SOURCE column to help this query respond.
ALTER TABLE email_table ADD KEY(SOURCE);
Then, try again.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Rob Kudyba <[EMAIL PROTECTED]> wrote on 11/04/2004 02:02:09 PM:
> Wow even the 1st query seems to
Wow even the 1st query seems to be taking a while...been like 5 minutes.
The DB has "only" around 80,000 records. I do have an index key which is
"email_address_id" so would adding that in the query help speed it up?
Thanks for the quick reply & suggestion...
[EMAIL PROTECTED] wrote:
This query
Rhino wrote:
- Original Message -
From: "Rob Kudyba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 12:26 PM
Subject: constructing a select and excluding duplicates
I am trying to construct a SELECT statement on distinct email
This query will list all of the email addresses where SOURCE='Source1' but
are not listed within any other source
SELECT et1.email_address
FROM email_table et1
LEFT JOIN email_table et2
on et2.email_address = et1.email_address
and et2.SOURCE <> 'Source1'
WHERE et1.SOURCE = 'Source
- Original Message -
From: "Rob Kudyba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 12:26 PM
Subject: constructing a select and excluding duplicates
> I am trying to construct a SELECT statement on distinct email addresses.
&g
The email addresses from source1 that are also not part of all of the
following sources (source2, source4, and source6).
What I meant was there are addresses that are duplicate and exist in
source 1, source 2, source 3, et. al. I want to only include the
distincts from all of them, in other wor
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 addresse
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
