question

michael.smith avatar image
1 Like"
michael.smith asked Joerg Vogel commented

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?

sqltablescalculated table
· 3
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joerg Vogel avatar image Joerg Vogel commented ·

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

0 Likes 0 ·
michael.smith avatar image michael.smith Joerg Vogel commented ·

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

0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel michael.smith commented ·

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 Likes 2 ·
combine-tables-sql-query.jpg (143.5 KiB)

1 Answer

Ralf Gruber avatar image
3 Likes"
Ralf Gruber answered

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

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.