title: Difference between INNER JOIN and LEFT SEMI JOIN
body: <p>What is the difference between an <code>INNER JOIN</code> and <code>LEFT SEMI JOIN</code>? </p>
  
  <p>In the scenario below, why am I getting two different results? </p>
  
  <p>The <code>INNER JOIN</code> result set is a lot larger. Can someone explain? I am trying to get the names within <code>table_1</code> that only appear in <code>table_2</code>.</p>
  
  <pre><code>SELECT name
  FROM table_1 a
      INNER JOIN table_2 b ON a.name=b.name
  
  SELECT name
  FROM table_1 a
      LEFT SEMI JOIN table_2 b ON (a.name=b.name)
  </code></pre>