Jamil Muammar
asked on
Update table fields from other table by fields
Dear Experts,
How do I update fields in table from other table fields by keys.
Example
Table1 fields are ( Year, Customer, Product, Revenue, Quantity, Region)
I need to update only Revenue & Quantity from Table 2 according to the Keys Year, Customer, Product
Table2 Fields (Year, Customer, Product, Revenue, Quantity )
Thanks
How do I update fields in table from other table fields by keys.
Example
Table1 fields are ( Year, Customer, Product, Revenue, Quantity, Region)
I need to update only Revenue & Quantity from Table 2 according to the Keys Year, Customer, Product
Table2 Fields (Year, Customer, Product, Revenue, Quantity )
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.experts-exchange.com/questions/29095348/Oracle-Update-one-table-from-another-table-with-join.html?anchorAnswerId=42538066#a42538066
Personally, I prefer the MERGE example but the other one should work as well.