Ended up finally creating a VIEW in the database to handle the problem.
Even on a 15,000 record list, runs in just a few seconds...
| SELECT DISTINCT nl_catREL.groups_id, duplicates.ml_id
FROM nl_catREL
INNER JOIN
nl_mailgroupsON nl_mailgroups.ml_id = nl_catREL.ml_id
INNER JOIN
nl_mailgroupsAS duplicatesON duplicates.ml_email =
nl_mailgroups.ml_email
AND duplicates.ml_id > nl_mailgroups.ml_id|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359653
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
