It was pretty close. Running it in "one direction", knowing that table B has extra records, works fine.
----- Original Message ----- From: "Dawson, Michael" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, February 11, 2008 7:59 PM Subject: RE: Query Help - find unique rows in two similar tables > You know... This probably won't work. I don't have access to a > database server right now to test this. I'm trying to picture the > results, but it's late and my brain is foggy. > > M!ke > > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Monday, February 11, 2008 8:45 PM > To: CF-Talk > Subject: RE: Query Help - find unique rows in two similar tables > > SELECT > a.* > ,b.* > FROM > TableA a > FULL OUTER JOIN TableB b > ON a.id = b.id > WHERE > a.id IS NULL > OR > b.id IS NULL > > (Untested) > > M!ke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:298771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
