The SQL UNION operator combines the result of two or more SELECT statements.
Select city from person union select city from suppliers order by city
Select city from person union all select city from suppliers order by city

MS-SQL Intersect

The SQL Intersect operator shows only the common data from two tables.
Select city from person intersect select city from suppliers order by city
Select city from person intersect all select city from suppliers order by city