title: How to find non-existing data from another Table by JOIN?
body: <p>I have two tables TABLE1 which looks like:</p>
  
  <pre><code>id      name     address
  1       mm     123
  2       nn     143
  </code></pre>
  
  <p>and TABLE2 w/c looks like:</p>
  
  <pre><code>name     age
  mm      6
  oo      9
  </code></pre>
  
  <p>I want to get the non existing names by comparing the <code>TABLE1</code> with the <code>TABLE2</code>.</p>
  
  <p>So basically, I have to get the 2nd row, w/c has a NN name that doesn't exist in the <code>TABLE2</code>, the output should look like this:</p>
  
  <pre><code>id      name     address
  2      nn      143
  </code></pre>
  
  <p>I've tried this but it doesn't work:</p>
  
  <pre><code>SELECt  w.* FROM TABLE1 W INNER JOIN TABLE2 V
    ON W.NAME &lt;&gt; V.NAME
  </code></pre>
  
  <p>and it's still getting the existing records.</p>