Thanks for you input Justin, But I think I need to find a workaround .... in a typical case of this page the original list holds 30-90.000 addresses .... and the partial list contains 0-90.000 addresses ..... needless to say that this query takes forever...
=) @llan -----Original Message----- From: Justin Scott [mailto:[EMAIL PROTECTED]] Sent: Friday, May 03, 2002 11:42 AM To: CF-Talk Subject: Re: Simple question .... QueryOfQuery > <cfquery name="results" dbtype="query"> > select email > from qFullList > where address not in (qPartialList.address) > </cfquery> The "where address" should read "where email" .. sorry for any confusion. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
