Creating New Table from fields from 2 existing tables

I would like to create a new table using particular columns from an existing table 1 and an existing table 2. Some of these columns are the same fields in both table 1 and table 2 (e.g. First Name, Last Name, Target Start Date, and a few others). There are some columns in table 2 that are not contained in table 1. I would like to add these columns to the newly created table. The expected result would be that the rows brought over from table 2 would have information in this column and the rows already populated in the new table from table 1 would be blank. In addition, any rows that I bring over to the new table from table 1, I would like to filter based on a status field in table 1. Any rows that I bring over to the newly created table from table 2 I would also like to filter based on a status field contained in table 2. What is the best way for me to accomplish the above? Thanks in advance!!