Glad it's working for you. I really wish QofQ would support the "INNER JOIN table_name tn ON tn.column_name = " syntax. To me, it is a lot easier to visually see how each table is being tied into the results.
I have seen an incomplete join bring down the server when two large tables were joined together with no criteria. Like Jochem said, that is a Cartesian join, which means EVERY POSSIBLE combination of records from both tables will be returned. Let's say you join two tables together that both have only 1,000 records. You're going to get 1,000,000 records back. This effect grows exponentially. ~Brad -----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 12:13 PM To: CF-Talk Subject: Re: query of query timing out ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i needed it to do the valuelist stuff as you said. it has sped it up thanks. you stated that i hadnt added any join clauses but as i think you guessed there was not meant to be a join thanks brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
