在SQL Server中创建一个包含2个组合表中最大值的表

Currently running into a problem with SQL Server (SSMS 17.4), I have combined 2 tables with different columns into 1 table, making use of the unique ID done in Currently running into a problem with SQL Serve