I’m learning MERGE or UPSERT (UPDATE + INSERT), which according to wikipeda, has the form: MERGE INTO tablename USING table_reference ON (condition) WHEN MATCHED THEN UPDATE SET column1 = value1 [, column2 = value2 …] WHEN NOT MATCHED THEN INSERT (column1 [, column2 …]) VALUES (value1 [, value2 …]); , and: If the ON field(s)Read more