Okies...i thought there was a function in sql called "In"...but I can't seem to find any info on it... What do you guys suggest would be the best way to determine which rows are in one tabe, but not another table? Both tables have the same layout (fields, etc)
~~ Stephenie > |-----Original Message----- > |From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]] > |Sent: Wednesday, October 16, 2002 12:31 PM > |To: CF-Community > |Subject: RE: Db merge question > | > | > |After I update the old db, I don't need the new one... > |I need to make the old one match the new one and for some > |reason the customer doesn't want the old one just replaced > |with the new one... > | > |I think I am going to create a tmp table in the old db, then > |bring in the data from the new db so I can then see what > |needs to be done to the old db as far as > |delete/insert/update etc... That way everything is in one dsn. > | > |~~ > |Stephenie > | > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.401 / Virus Database: 226 - Release Date: 10/9/2002 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
