sql join select results to column 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
SELECT table1.Column1, table1.Column2
FROM table1
UNION
SELECT table2.Column1, table2.Column2
FROM table2