get output of 2 sql tables as 1 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