Importing more than one table in a single query?

[JunBICons]

Hi everyone!
I use Blank Query and this formula to retrieve my data;

let 
    Source = (sql_instance as any) =>
    let
        Result = Sql.Database(sql_instance, "ProductionDB", [Query="SELECT * FROM Table1"])
    in
        Result
in Source

 However, I can import only Table1 in this way, and I need to import all columns of Table2, Table3, Table4, Table5, Table6 and Table7 as well in a single query -they're in the same ProductionDB database-
How should I reformulate the code to get seven tables at once? 
Thank you very much for your help in advance!

[ImkeF]

Hi @JunBICons ,
not sure I understand your requirement, but I would recommend to try the first solution.

[ImkeF · Accepted solution]

Hi @JunBICons ,
not sure how the tables relate to each other, but you could either append them with a UNION ALL statgement like so:

Query="SELECT * FROM Table1 
UNION ALL SELECT * FROM Table2 
UNION ALL SELECT * FROM Table3
..."

or perform joins like so:

SELECT *
FROM Table1
LEFT JOIN Table2
ON Table1.KeyColumn=Table2.KeyColumn
LEFT JOIN Table3
ON Table1.KeyColumn=Table3.KeyColumn
...