select * from table1

union all

select * from table2


// ----------------
If one table has more columns than the other, then in the table with the fewer columns, add ,null to the end of the select statement to add columns to the results.  Add as many ",null"s as you need to match the number of columns to the other table.

select * from table1

union all

select *, null from table2

This is how to run 2 separate queries and display them in the same window in order to compare the results.

You need to add the union all in between the queries.  Then add a comma and null to the second query.

SQL:  How To Display & Compare 2 Query Results In The Same Window

SQL