Join the 2 tables with a union:
select Column1, Column2 from Table1
union
select Column1, Column2 from Table2
You'll need to take care of sorting and making sure that both tables have the same number of columns.
You can add dummy columns to the table with fewer columns as:
select Column1, null from Table2