sql update statement with result from another select 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=...
UPDATE table1
SET table1.Price = table2.price
FROM table1 INNER JOIN table2 ON table1.ID = table2.id
-- WHERE table1.id=...