title: SQL Query in Access that lists values not in both tables
body: <p>I need to find out which drivers have not purchased fuel in the last 6 months.</p>
  
  <p>I have two tables TransactionReport (all transactions from the last 6 months) and DriverList (all drivers) </p>
  
  <pre><code>TransactionReport
  DriverID  |  DriverLastName | DriverFirstName | Other Columns not used for this query
  
  DriverList
  DriverID  |  DriverLastName | DriverFirstName | Other Columns not used for this query
  </code></pre>
  
  <p>I would like to return all the DriverID's listed in DriverList that are not listed in TransactionReport.</p>
  
  <p>Results should look give me the following</p>
  
  <pre><code>DriverID  |  DriverLastName | DriverFirstName
  </code></pre>