Are the other fields in your table the same when the email is the same? Meaning, are the records really duplicate? Or is it just the email that is duplicate and the other fields may have varying values for two rows that have the same email? If they do vary, do you care which of the "duplicate" rows you return?
Judah On Tue, Sep 16, 2008 at 7:50 AM, Jeff F <[EMAIL PROTECTED]> wrote: > Thanks Jim. Now I see. > > I guess what I'm looking for would be something like this then: > > SELECT mytable.lastname,mytable.email > FROM mytable GROUP BY mytable.email HAVING distinct(mytable.email) > > Which of course does not work. When there are records with duplicate emails > addresses, I need to include one of them. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:312597 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4