Oracle SQL update based on subquery between two tables - Stack Overflow

There are two ways to do what you are trying One is a Multi-column Correlated Update UPDATE PRODUCTION a SET (name, count) = ( SELECT name, count FROM STAGING b WHERE a.ID = b.ID); DEMO You can use merge MERGE INTO PRODUCTION a ...

stackoverflow.com