Forum Discussion

luisseneto's avatar
luisseneto
New Member
7 years ago
Solved

Create a new table from multiple tables

Hi,   I'm trying to joining multiple tables and i dont know how to do it.     Table 1: id name value 1 aaa 123 2 bbb 234 3 ccc 345   Table 2: id name value 1 ...
  • mwegener's avatar
    7 years ago

    Hi luisseneto,

     

    1. rename the value columns (Table1.value, Table2.Value)

    2. Append Table1 & Table2

    3. Group by id, name (Sum Table1.Value, Table2.Value )