如何合并/更新2个相同的SQL表

I have 2 SQL tables with the same structure. One is an updated version of the second. How can I merge the 2 so that the newer table's records take precedence over the other, and records that do not have updates in the newer table are still included? I have 2 SQL tables with the same structure. On