title: How to compare two tables and show every difference
body: <p>I got two tables with each 1 column. I want to compare those column and see if they are the same. The two tables look something like this:</p>
  
  <p>Table one:</p>
  
  <pre><code>-----
  | 1 |
  -----
  | 2 |
  -----
  | 3 |
  -----
  | 4 |    
  -----
  | 5 |
  -----
  | 6 |
  -----
  | 7 |
  -----
  | 8 |
  -----
  | 9 |
  -----
  </code></pre>
  
  <p>Table two:</p>
  
  <pre><code>----- &lt;-- missing `1` in table 
  | 2 |
  ----- &lt;-- missing `3` in table 
  | 4 |    
  -----
  | 5 |
  -----
  | 5.5 | &lt;-- extra `5.5` in table 
  -----
  | 6 |
  -----
  | 8 | &lt;-- this one isnt the same as the `7` in table one
  -----
  | 7 | &lt;-- this one isnt the same as the `9` in table one
  -----
  | 9 |
  -----
  </code></pre>
  
  <p>And the SQL query should return a table like this:</p>
  
  <pre><code>-----------------
  | Table1| Table2|
  ----- -----------
  | 1     |       |
  ----- -----------
  | 3     |       |
  -----------------
  |       | 5.5   |
  -----------------
  | 7     | 8     |
  -----------------
  | 8     | 7     |
  -----------------
  </code></pre>
  
  <p>So if one value is only in 1 of those tables, it needs to be <code>selected</code>. Also if in table two the string after the previous string is not the same as the string after the previous string in table one, it needs to be <code>selected</code></p>