%sql --merge syntax --merge into targetable using sourcetable on condition_to_join --when matched then update --when not matched then insert --when not matched by source then delete (some additional ...