dokuwiki

merge into accountants a
using employees e
on (e.last_name = a.last_name and e.first_name = a.first_name)
when matched then
 update set salary = e.salary where last_name = 'Abel'
when not matched then
insert (first_name, last_name, salary) values (e.first_name, e.last_name, e.salary)