Oracle SQL: Update a table with data from another table – Stack Overflow


UPDATE (SELECT t1.id, t1.name name1, t1.desc desc1, t2.name name2, t2.desc desc2 FROM table1 t1, table2 t2 WHERE t1.id = t2.id) SET name1 = name2, desc1 = desc2

solution

Source: Oracle SQL: Update a table with data from another table – Stack Overflow

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑