Update question

[Jørn Dahl-Stamnes]

Please, I nedd help!!

I have two tabels:

table1:
	id
	value

table2:
	id
	value

Both tables has a lot of records with identical IDs. I need to update the 
table1.value with the table2.value where the id are identical.

But I cannot find any UPDATE query that can do this in a single operation. 
Anyone that can give me a suggestion?

I'm using MySQL 4.1.8

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/