Does anyone know how I would go about setting up a CFQUERY where I can get ALL
fields where one column has duplicate values, and that column needs to be
de-duped? I thought something like this would work:
Select DISTINCT email, id, first, last from myTable
but it returns all rows because the ID column is a primary key and has no
duplicates. Essentially, if one person is in the database twice, he'll have two
different ID numbers, but I need to throw away one of them. Is there an easy
way to do this?
tom
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
