ok im getting there and have narrowed it down to 1 more problem - i hope!! the problem is coming from the second part of the union where i am trying to find the rows that are eliminated in the first inner join part
this problem only stems from the fact that i have more than 1 primary key if i had only 1 primary key then saying where queryA.ID not in #valuelist(queryB.id)# would work fine but what i have been doing is the following: where queryA.ID1 not in #valuelist(queryB.id1)# and queryA.ID2 not in #valuelist(queryB.id2)# and queryA.ID3 not in #valuelist(queryB.id3)# and this is returning nothing, which is now obvious to me as it is not looking correctly at all the 3 ids to see which combination of the ids dont exist, it is looking at one column at a time and to see which id1 are not there, then which id2's are not there etc... instead of looking at them as a combination of three does anyone know how i can achieve this: if this explanation is not clear then i can provide an example thanks 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:308401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
