Forum Discussion

im_newbie_123's avatar
im_newbie_123
Frequent Visitor
6 years ago

Use advanced power query editor to use SQL statement

I have a sql statement which is union of two tables.   I want to use the sql statement inside advaced query editor.   My SQL Statement : SELECT [ABC],[XYZ] FROM TABLE1 UNION SELECT [PQR],[YAA]...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

You could write the SQL in PowerQuery:

= Table.NestedJoin(#"weekly report", {"Unique ID"}, Tracker, {"Unique ID"}, "Tracker", JoinKind.LeftOuter)