Query of Queries problem

[Biglop]

I'm trying a Q of Q for the first time and I must be doing something wrong. Can somebody enlighten me? I have two databases, both with email addresses. I want to come up with a list of addresses from DB1 that are not in DB2.

Here's what I tried:

<cfquery name=&quot;addresses_phx&quot;
datasource=&quot;email_phx&quot;
dbtype=&quot;ODBC&quot;>
SELECT first_name, email
FROM email_addresses
</cfquery>

<cfquery name=&quot;addresses_ibs&quot;
datasource=&quot;apps_copy&quot;
dbtype=&quot;ODBC&quot;>
SELECT Email
FROM IBS_apps
</cfquery>

<cfquery name=&quot;queryofqueries&quot;
dbType=&quot;query&quot;>
SELECT email
FROM addresses_phx, addresses_ibs
WHERE addresses_phx.email NOT IN addresses_ibs.email

</cfquery>

<cfoutput query=&quot;queryofqueries&quot;>
#addresses_phx.email#

</cfoutput>

 

[tleish]

Are you using CF Server 5.0? What is the error you are getting? - tleish

 

[Biglop]

I don';t get an error message, it just hangs and eventually depletes server memory.