Check out example codes for "sql view where tables have same column name combine results". It will help you in understanding the concepts better.

Code Example 1

SELECT table1.Column1, table1.Column2
FROM table1

UNION

SELECT table2.Column1, table2.Column2
FROM table2

Learn ReactJs, React Native from akashmittal.com