Create Multiple Tables From One SQL Statement

[Anonymous]

I have two tables I need created.  I am pulling data from a SQL server, then writing a SQL statement that generates some temp tables, that I end up joining together to create the first power BI table.  Then I need to take 90% of these temp tables and add a few more temp tables to create the second Power BI table.   I know I can create this as two SQL statements and get my two tables.  What I want to do though, is write ONE sql statement and have it output two different tables (just like you can do with SQLQuery with multiple Select Statements).

[lbendlin]

You can run any number of SQL queries, but the final result must be a single table.  What you can do is UNION ALL the two tables in SQL and then separate them in Power Query.