select one table from two tables with same primary key but different value?
<pre><code>Table1           Table2

id  | name       id   | name
-----------      ------------
2   | A           2   |  E   
4   | B           3   |  F
6   | C           4   |  G
8   | D           5   |  H    
</code></pre>

<p>Output:</p>

<pre><code>Id  |  name
------------
2   |  A *** E
4   |  B *** G
6   |  C *** EMPTY
8   |  D *** EMPTY
3   |  EMPTY *** F
5   |  EMPTY *** H
</code></pre>