title: Select unmatched records from two tables of MYSQL
body: <p>I have two tables Table1 and Table2 with some records</p>
  
  <p>id is the common column in both tables and primarykey is set to this column in table1</p>
  
  <p>There are many records in table1 and some of these records (not all) are updated into table2.</p>
  
  <p>Now I want retrieve from table1 the records not updated into the table2.</p>
  
  <p>For example in table1 there are records 1,2,3,4,5,6,7,8,9</p>
  
  <p>And in table2 there are 3,4,7,9</p>
  
  <p>Now How can I retrieve these records form table1 1,2,5,6 those not updated into table2</p>
  
  <p>I wrote this query :</p>
  
  <pre><code>SELECT Table1.id, Table1.DATE, Table1.C_NAME, Table1.B_NAME
  FROM [Table1] INNER JOIN Table2 ON Table1.SLIPNO &lt;&gt;Table2.id;
  </code></pre>
  
  <p>But the expected result not coming. This query lists all the records repeating each one record manytimes</p>
  
  <p>Can any body give me solution to get the expected result.</p>