Union two tables with different columns names

[Ohad]

Hi,

I have two tables with different names for the columns but with the same meaning and I need to union the two tables to one table with the names of the columns in table A.

Do I need to create a new table (table C)? If so, how? Or is there a better way to do it?

Index

Opening_Date = Business_Date

Store_Name = Location

Store_Number = Location_Code

Table A

Opening_Date                  Store_Name                      Store_Number

1/1/2017                           New York                                  1

Table B

Business_Date                  Location                            Location_Code

2/1/2017                           Boston                                      2

Table C

Opening_Date                  Store_Name                      Store_Number

1/1/2017                           New York                                  1

2/1/2017                           Boston                                      2

Thank you,

Ohad