title: SQL union and removing duplicates base on priority
body: <p>Please have a look at SQLFiddle below <br>
  <a href="http://sqlfiddle.com/#!2/5dd713/2/0" rel="nofollow">http://sqlfiddle.com/#!2/5dd713/2/0</a></p>
  
  <p>I have two tables. And I union both tables to get the data that I am looking for 
  But I would like to remove the duplicates and use info from table1 as the priority </p>
  
  <p>currently the table looks like this (info1 comes from table1 and info2 comes from table2)</p>
  
  <pre><code>1, info1
  2, info1
  3, info1
  3, info2
  4, info1
  4, info2
  5, info1
  5, info2
  6, info2
  7, info2
  </code></pre>
  
  <p>So the end result will look like below</p>
  
  <pre><code>1, info1
  2, info1
  3, info1
  4, info1
  5, info1
  6, info2
  7, info2
  </code></pre>
  
  <p>how can I do this?</p>
  
  <p>thank you</p>