Insert or update rows in one table based on a selection from another table.
Merge update
Merge insert