SELECT column_name(s) FROM table_name1
UNION
SELECT column_name(s) FROM table_name2

example

SELECT E_Name FROM Employees_Norway
UNION
SELECT E_Name FROM Employees_USA