append/calculate two different tables

Hi,

I have two data tables that I would like to aggregate. They have different column names and orders. 

Could you please let me know how would you aggregate both tables?

For instance:

• Table 1 has the following columns: Client name, client country, supplier name, supplier country
• table 2 has the following columns: Supplier name, Supplier Country

I want to create an aggregated table that would have Supplier Name and Supplier country data from both tables.

Thank you in advance.

Kind regards,

Salvador