title: Showing all records in JOIN clause in database
body: <p>I have two tables, named <code>voter</code> and <code>log_vote</code>. <code>Voter</code> contains data of voters while <code>log_vote</code> contains data of voters who have voted.</p>
  
  <p>Now I'm trying to show the voters <strong>who haven't voted</strong>. I have tried using JOIN in both tables but it will fail since JOIN clause only shows voters that have voted of course.</p>
  
  <p>Here's the code snippet which I've tried:</p>
  
  <pre><code>SELECT * FROM voter INNER JOIN log_vote ON log_vote.nim = voter.nim
  </code></pre>
  
  <p>How to show only voters who haven't voted? Is using JOIN a correct way to do? Thanks in advance, I will really appreciate for the answer!</p>
  
  <p>*NOTE: I'm using PHP Technology. Wonder if there's any way that PHP can do with my problem.</p>