title: Comparing two tables in SQLite
body: <p>I have two tables and want to compare rows on sqlite like this</p>
  
  <pre><code>table1           table2
  field1           field1
  
  a                   a
  b                   d
  c                   f
  d                   g
  e
  f
  g
  h
  i
  </code></pre>
  
  <p>and I want to produce result like this</p>
  
  <pre><code>result_table
  field1
  
  b
  c
  e
  h
  i
  </code></pre>
  
  <p>How is the syntax in sqlite?
  Thanks</p>