how to join two tables with same column name in sql code example

Example: sql view where tables have same column name combine results

SELECT table1.Column1, table1.Column2
FROM table1

UNION

SELECT table2.Column1, table2.Column2
FROM table2