update a particular row with another table sql code example

Example: sql update from another table

UPDATE table1 
   SET table1.Price = table2.price 
   FROM table1 INNER JOIN table2 ON table1.ID = table2.id
   -- WHERE table1.id=...