How to copy a column's values to another similar table 1

[hapax]

I have GamesNew table and a GamesOld table that are mostly copies of each other, although the GamesNew has some new rows that are not in GamesOld. In the GamesNew table there is a Description column that now has bad data.

For each GamesNew.GameId I want to update the Description column with the contents of the Description column of the corresponding GamesOld.GameId. I'm don't know how to do this.

Here is my attempt so far:

UPDATE GamesNew
SET GamesNew.Description = GamesOld.Description
WHERE GamesNew.GameID = GamesOld.GameID

But it throws an error: "The multi-part identifier "GamesOld.GameID" could not be bound." I think I need a FROM statement or something but I don't know where to add that to an UPDATE statement.

 

[gmmastros]

You were close.

UPDATE GamesNew
   SET GamesNew.Description = GamesOld.Description
  FROM GamesNew
       Inner Join GamesOld
          On GamesNew.GameID = GamesOld.GameID

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[hapax]

Excellent. Thank you