Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Importing more than one table in a single query?

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!

Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi Anonymous ,
    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
...



2 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

    Hi Anonymous ,
    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
...



  • ImkeF's avatar
    ImkeF
    Community Champion
    3 years ago

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