title: mySql query to find records not present in another table
body: <p>I had two mySql tables of <code>CARS</code> and <code>DRIVERS</code> with the attribute <code>licenseNumber</code><br>
  as a foreign key.  </p>
  
  <p>What would be the query to find the names of the drivers who did not have a car?</p>
  
  <p>I was thinking:</p>
  
  <pre><code>SELECT DISTINCT D.name
  FROM drivers D, cars C
  WHERE 
   D.licenseNumber = C.licenseNumber AND 
    D.licenseNumber NOT IN (SELECT licenseNumber FROM cars)
  </code></pre>
  
  <p>But that doesn't return anything.<br>
  I have a feeling I'm overthinking it a bit.<br>
  Any help? </p>