Calculated Tables Append Multiple Tables into one?

Question

question

michael.smith asked Oct 19, '17 Joerg Vogel commented Oct 19, '17

Calculated Tables Append Multiple Tables into one?

Is it possible to append multiple tables (various feed tables) into a single table using either Calculated Tables or the SQL Available?

sql tables calculated table

· 3

Joerg Vogel commented · Oct 19, 2017 at 04:19 AM

I think you probably doesn't mean the SELECT FROM clause where you can create a really large table for a SQL query.

0 ·

michael.smith Joerg Vogel commented · Oct 19, 2017 at 05:54 AM

I was looking to Select from multiple tables, couldn't see that as a method but I might have missed it

0 ·

Joerg Vogel michael.smith commented · Oct 19, 2017 at 06:44 AM

From the Developer and Advanced User Reference:

a standard construct is FROM

Inner joins via comma-separated tables

This means you can combine multiple tables in your query, if you seperate them by commata after the construct word FROM.

2 ·

combine-tables-sql-query.jpg (143.5 KiB)

Answer 1 · 2017-10-19T06:29:03Z

Ralf Gruber answered Oct 19, '17

Michael,

you can select columns from multiple tables to combine into one with this syntax:

Table.query("SELECT tablename1.[columnname], tablename2.[columname]..."

Best wishes

Ralf

question