This article is tagged with:
Sql update with field from another table
and mysql
sql update with field from another table
UPDATE table1
SET price=(SELECT price FROM table2 WHERE table1.id=table2.id);