Construction should include using the following format:
MERGE INTO table-name USING table/view/subqueryON what join conditionWHEN MATCHED THEN UPDATE SETCol1 = Col2 valueWHEN NOT MATCHED THENINSERT (column_list)VALUES (column_values)