update columns values with column of another table based on condition

Question

I have two tables     table1   id  item  price   values   id   item   price ------------- 10   book   20   20   copy   30    30   pen    10       table2   id  item  price  values   id   item   price ------------- 10   book   20 20   book   30   Now I want to   update table1     set table1 Price   table2 price   where table1 id   table2 id    and table1 item   table2 item    How do I do it

User · Answer

This will surely work   UPDATE table1 SET table1 price  SELECT table2 price   FROM table2   WHERE table2 id table1 id AND table2 item table1 item

User · Answer

Something like this should do it     UPDATE table1     SET table1 Price   table2 price     FROM table1  INNER JOIN  table2 ON table1 id   table2 id   You can also try this   UPDATE table1     SET price  SELECT price FROM table2 WHERE table1 id table2 id

[sql] update columns values with column of another table based on condition

Examples related to sql

Examples related to mysql

Examples related to sql-server

Examples related to oracle