In is like in a list of items you specify You can do a join that shows all the items in table A where the id field in table B is null
----- Original Message ----- From: "Stephenie Hamilton" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Wednesday, October 16, 2002 9:34 AM Subject: RE: Db merge question > 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
