title: Comparison of two tables in MYSQL
body: <p>I have two tables. One table (table1) has 28500 rows and the another (table2) has 17450 rows.
  I would like to compare these tables and find rows that do not exist in table1.</p>
  <pre><code>SELECT * FROM table1 WHERE ID NOT IN (SELECT DISTINCT(ID) FROM table2)
  </code></pre>
  <p>Any suggestions?</p>