Have you tried unions? Another option is to convert the email query to a list and run it through a custom tag like cfx_listsort which can sort the list and dedupe it.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:12 AM To: CF-Talk Subject: <cf_filter_duplicate_emails_from_query> Hello, I am querying 3 tables that all contain email addresses. What I want to do is send an email using all the email addresses. I just want to make sure there aren't duplicate e-mail when i sent the email. I need some advice on how to remove duplicates. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
