And thanks to Ben as well (and anyone else I missed), who also went into NoSpamToday (usually a product I have no hassles with).
Mark -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: 29 February 2008 04:42 To: CF-Talk Subject: Re: SOT - SQL Union Problem I'm not an SQL guru, so take this with a grain of salt: You could do a join on table1.firstname=table2.firstname and table1.firstname = table2.lastname to get all the results that match. You could union this to two unioned selects where there's an entry in table1 but not table2 and vice versa. You'll have to select empty strings for the columns that are only present in one or the other table. This should give you a result set where you either have the addresses from one, or the other, or both. You can make display (or further processing) decisions based on that. --Ben Doom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:300137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
