Ok, good luck. Note: I had to fiddle a little bit for my example to work. For instance, there needed to be () around the output of the valuelist etc, but I assumed that had been omitted in your post as an oversight or for simplicity.
You can start by dumping your two queries and visually confirming that what you think exists in them actually does. ~Brad -----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2008 3:14 PM To: CF-Talk Subject: Re: left outer join on query of query function thanks for the description brad, yes sorry i wrote it wrong they do exists in query a and not in query b so i want to find those that exist in querya and not in query b. however your example is quite detailed and shows that the 'where not ()' clause should do the trick so there must be something else i am missing either in my code or previous outputs. i will output everything slowly to see why it is not returning the rows as expected thanks again for your help ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4