Forum Discussion

Ohad's avatar
Ohad
Frequent Visitor
9 years ago
Solved

Union two tables with different columns names

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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Ohad,

     

    In this scenario, you can also try the Append Queries option in Query Editor.:smileyhappy:

     

    1. Rename the three columns in Table B with the column names in Table A.

     

    2. Select Table A, and choose "Append Queries as New" under Home tab in Query Editor.

     

     

    Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Ohad,

     

    Great to hear the problem got resolved! Could you accept the helpful replies as solution to help others who may have similar issue easily find the answer and close this thread?:smileyhappy:

     

    Regards