Updating from one table to another

[Guest_imported]

I am having the hardest time trying to preform an update of data from one table to another. For example:
I have a table with ID(key), Name, address,Phone,other fields, and another table that have the ID(Key), and
Phone(corrected). I Would like to Update the Phone in the first table to be the phone in the second table, joined on the ID.

 

[foxdev]

How about:

update TableA set phone = 
  (select phone from TableB where TableB.ID = TableA.ID)

 

[calahans]

Try:

UPDATE TABLE1
SET TABLE1.PHONENO=TABLE2.PHONENO
FROM TABLE2
WHERE TABLE1.ID=TABLE2.ID

Should work