Update Table Column Value from another Table (Optional Way of Inner Join)
Yesterday, i was working on sql Store procedure to update table data from other table, and Inner Join is best way to update from another table.
but there is too many raw so i was confused in use of inner join.
My senior teach me another way of updating column value.
Table1 DiamondMaster
id | Shape | Color | Lab | Price
-----------------------------------
1001 | Round | White | GIA | 50000
1002 | Heart | Red | GIA | 80000
1003 | Round | White | IGI | 50000
Table2 DiamondNewPrice
id | NewPrice
---------------
1002 | 75000
1003 | 55000
1. First Way Using Inner Join
UPDATE DiamondMaster
SET DiamondMaster.Price = DiamondNewPrice.NewPrice
FROM DiamondMaster INNER JOIN DiamondNewPrice On DiamondMaster.id = DiamondNewPrice.id
2. Other Way
UPDATE DiamondMaster
SET DiamondMaster.Price = i.NewPrice FROM (select id, NewPrice from DiamondNewPrice) i where i.id = DiamondMaster.id
-------
Thanks