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)