Forum Discussion

baironaguillera's avatar
baironaguillera
Regular Visitor
9 years ago
Solved

Create table getting data from table hosted in another query

Hi all,   I need to create a table with 3 columns getting data from another tables that are in another queries.   I would like to use advanced editor to create this table.   Example: Column...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    baironaguillera

     

    Hi, Please follow the Image:

     

     

    If you need a New Merge Table Select Merge Queries as New 

baironaguillera's avatar
baironaguillera
Regular Visitor
9 years ago

Hi Vvelarde

 

In this example you merger 2 tables.

Is it possible merge another one using the same column name?

 

Then we will use 3 tables.

 

Tks!!

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi baironaguillera,

As I tested, we are unable to merge three table at one time. You can merge the two tables to one new table, then merge new table to third table.

Best Regards,
Angelia