title: Combining the result of two queries using SQLite
body: <p>Let's say I have the following tables:</p>
  
  <pre><code>Table A             Table B
  | a | b | c |       | a | b | c |
  |---|---|---|       |---|---|---|
  | a | b | c |       | a | b | c |
  | a | c | d |       | a | c | d |
  | c | d | e |       | a | b | c |
  | f | g | h |       | o | p | q |
  | a | a | a |       | a | b | c |
  </code></pre>
  
  <p>and I want to find all the rows that differ from both tables.</p>
  
  <p>This gives me the rows from A that are not in B:</p>
  
  <pre><code>SELECT a, b, c FROM A
  EXCEPT 
  SELECT a, b, c FROM B;
  
  | a | b | c |
  |---|---|---|
  | a | a | a |
  | c | d | e |
  | f | g | h |
  </code></pre>
  
  <p>and this gives me the rows from B that are not in A:</p>
  
  <pre><code>SELECT a, b, c FROM B
  EXCEPT 
  SELECT a, b, c FROM A;
  
  | a | b | c |
  |---|---|---|
  | o | p | q |
  </code></pre>
  
  <p>So to combine the two I tried using </p>
  
  <pre><code>SELECT a, b, c FROM A
  EXCEPT 
  SELECT a, b, c FROM B
  UNION
  SELECT a, b, c FROM B
  EXCEPT 
  SELECT a, b, c FROM A;
  </code></pre>
  
  <p>but it still only gives me the rows from B.</p>
  
  <p>How do I get rows from both tables, like this?</p>
  
  <pre><code>| a | b | c |
  |---|---|---|
  | a | a | a |
  | c | d | e |
  | f | g | h |
  | o | p | q |
  </code></pre>