title: Output values which not exists in a table
body: <p>I have 2 tables driver and driver_photo. In driver_photo we are writing driver_id and his photos.
  I need to make a list of drivers which are not present in driver_photo.
  So the output should be like this:</p>
  
  <pre class="lang-none prettyprint-override"><code>Callsign | Name
  324      | Some_Driver_Name
  571      | Some_Driver_Name
  </code></pre>
  
  <p>I've tried this </p>
  
  <pre><code>SELECT driver.callsign, driver.name 
  from driver_photo 
    JOIN driver ON driver_photo.driver_id = driver.id 
  where driver.id in (select id 
                      from driver 
                      where driver_ds_account_id = 16) 
  and driver.id is null;
  </code></pre>
  
  <p>But the output is nothing.</p>
  
  <p>Conditions for the query are <code>driver_id</code> in <code>driver_photo</code> = <code>driver.id</code> from <code>driver</code>
  <code>driver_ds_account_id</code> in <code>driver</code> = <code>16</code></p>
  
  <p>If <code>driver.id</code> is not present in <code>driver_photo</code> need to write his <code>callsign</code> and <code>name</code> in output else skip.</p>