Join two Summarized Tables

I created two summarized tables from two different queries. I then created colums ID(Table 1) and Id3(Table 2) to create a relationship between the two tables. The resulting relationship is a many-to-on (Table 2 to Table 1). I would like to combine these two tables and keep all the columns from both tables. I tried creating another summarized table from the two but it does not keep the excess rows from Table 1. Please assist.

Table 1Table 2