On Tue, Sep 16, 2008 at 10:13 AM, Jeff F <[EMAIL PROTECTED]> wrote: > SELECT distinct mytable.email > FROM mytable > I get 19588 as a recordcount.
This number would include email addresses that are duplicated in the table (but only a count of 1 for each distinct address). > SELECT mytable.lastname, > mytable.email > FROM mytable > GROUP BY mytable.email HAVING count(mytable.email) = 1 > I get 19162 as a recordcount. ?? This recordcount eliminates any email addresses that are duplicated in the table. Note that any email addresses that are duplicated are NOT INCLUDED in the results using this method. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4