如何将数据从另一个表中插入表中，可能存在重复键

I'm attempting to write a conditional query that inserts new rows into a table from data from another table, but if the PK already exists for that row, to update it instead. I came across I'm attempting to write a conditional query tha