title: How to retrieve non-matching results in mysql
body: <p>I'm sure this is straight-forward, but how do I write a query in mysql that joins two tables and then returns only those records from the first table that don't match. I want it to be something like:  </p>
  
  <p><code>Select tid from table1 inner join table2 on table2.tid = table1.tid where table1.tid != table2.tid;</code></p>
  
  <p>but this doesn't seem to make alot of sense!</p>