sql update with field from another table
snippet in sql

sql update with field from another table

user1687

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