User Tools

Site Tools


kurs:merge_with_table
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)
kurs/merge_with_table.txt · Last modified: 2014/09/10 21:22 (external edit)