Forum Discussion
luisseneto
7 years agoNew Member
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 ...
- 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 )
mwegener
Most Valuable Professional
7 years agoHi luisseneto,
1. rename the value columns (Table1.value, Table2.Value)
2. Append Table1 & Table2
3. Group by id, name (Sum Table1.Value, Table2.Value )
- luisseneto7 years agoNew Member
Thank you mwegener !!
- mwegener7 years ago
Most Valuable Professional
You are welcome