title: In SQLite, how do I select elements in one table that are not in other?
body: <p>I've two tables in SQLite:</p>
  
  <pre><code>Table1:
  -------
  id
  name
  
  Table2:
  -------
  id
  temp_name
  </code></pre>
  
  <p>My question is, how do I write an SQL query that returns names in <code>Table2</code> that are not in <code>Table1</code>?</p>
  
  <p>For example:</p>
  
  <pre><code>Table1:
  -------
  1, 'john'
  2, 'boda',
  3, 'cydo',
  4, 'linus'
  
  Table2:
  -------
  1123, 'boda'
  2992, 'andy',
  9331, 'sille',
  2,    'cydo'
  </code></pre>
  
  <p>In this example the SQL query should return elements <code>andy</code>, and <code>sille</code> from <code>Table2</code>, because they're not in <code>Table1</code>.</p>