Sonny, Sorry for the delay, as your original message got eaten by NoSpamToday on our Exchange server (go figure) and my time zone tends to have me in bed when the *rest of the world* is hard at work.
Awesome, thanks (yes I think it worked)! I do have one question however - when I do the original union on just first and last names I get a record count of 1192, but when using your union and left outer join I have 1202. Just an interesting side note but it does appear to be doing what I want, so I wont delve into the intricacies too much. Once again, the assistance is much appreciated. Mark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
