updating column values for a table based on another value in another table code example

Example: update a table with values from another table

UPDATE table1 
   SET price=(SELECT price FROM table2 WHERE table1.id=table2.id);