sql view where tables have same column name combine results
snippet in sql

sql view where tables have same column name combine results

user2151

SELECT table1.Column1, table1.Column2
FROM table1

UNION

SELECT table2.Column1, table2.Column2
FROM table2