How do I show all records in from two tables in a make-table query

[Guest]

I am trying to return all the records from two different tables with an
intermediate "join" connector line on a common field [part number] to both
tables. I realize some of my records will repeat but I want to proceed
anyway. Is there a way to return all the records from my first table and
second table in a make-table query? My first table has [part number] records
the second table doesn't have. My second table has many similar [part number]
records as my first table but also has additional records the first table
does not have.

Any point in the right direction would be greatly appreciated.

 

[[MVP] S.Clark]

Create the desired destination table.
Create an append query to get all from T1 and add to the dest table.
Create an append query to get all from T2 and add to the dest table.