CodingForums.com - View Single Post

Pilot1 · 09-30-2002, 05:22 PM

A little background might help here.
I have two tables one called final has 9000 entries, 9 colums, with one colum, "C" Containing some old data.
The new table final1 has 3000 entries, two colums "I" (Old Data) and "J" (New Data) . Since not all of the codes in the old table "Final" need to be replaced, only 3000 of them, And the new script has the 3000 that need to be replaced, I fuigured there has to be a way of querrying the two tables to Replace the old code with the new code if "C" found the old code it was equal to in "I"
I would like to change "final" where row C = "final1" colum I and replace that data with "final1" colum J
Hope that makes scense. This is bugging me.
Thanks everyone!
Michael

09-30-2002, 05:22 PM	PM User \| #1
Pilot1 New to the CF scene Join Date: Sep 2002 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	Complex Querry A little background might help here. I have two tables one called final has 9000 entries, 9 colums, with one colum, "C" Containing some old data. The new table final1 has 3000 entries, two colums "I" (Old Data) and "J" (New Data) . Since not all of the codes in the old table "Final" need to be replaced, only 3000 of them, And the new script has the 3000 that need to be replaced, I fuigured there has to be a way of querrying the two tables to Replace the old code with the new code if "C" found the old code it was equal to in "I" I would like to change "final" where row C = "final1" colum I and replace that data with "final1" colum J Hope that makes scense. This is bugging me. Thanks everyone! Michael