How to link/join two tables and create a 3rd table based on those 2 tables

[sabha]

Hi, I have Table 1 and Table 2. Both have different data. I want to create a table 3 that includes both table 1 and 2. The end goal is for table 3 to automatically update when I update table 1 or 2. Below is a view

Would appreciate all the help! thank you!