update record value in one table based on 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);
UPDATE table1
SET price=(SELECT price FROM table2 WHERE table1.id=table2.id);