merge results on one table into another 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