IF there is a primary key on the tables, join them on the primary key and insert into the third table. For the example you have shown below, assuming col1 is the primary key and assuming if there are conflicts you want to give preference to values in Table 1:INSERT INTO YourThirdTable(col1, col2, col3, col4, col5)SELECT COALESCE(a.col1,b.col1), COALESCE(a.col2,b.col2), COALESCE(a.col3,b.col3), COALESCE(a.col4,b.col4), b.col5FROM Table1 a FULL JOIN Table2 b ON a.col1 = b.col1;