title: Alternative of UNION in sql server
body: <p>I have 2 tables which contains 5 unique cities each. I want all 10 cities but i don't want to use UNION. Is there any alternative for UNION.</p>
  
  <pre><code>SELECT DISTINCT CITY FROM TABLE1
  UNION
  SELECT DISTINCT CITY FROM TABLE2
  </code></pre>