title: Can't find missing matching rows in SQL join
body: <p>Quite new to SQL so please be patient. <br>I have two tables, one is a <code>Locations</code> table and one is a <code>FileImport</code> table. <br>I get files daily and I then import them they then get sorted based on the <strong>Locations</strong> in the <code>Locations</code> table. <br>My usual method of tracking the missed ones are done via Excel but there must be a simpler way through SQL.<br> I currently have the following query:</p>
  
  <pre><code>SELECT dbo.Location.LocationDesc, 
         dbo.FileImport.LocationName, 
         dbo.FileImport.CreatedDate, 
         dbo.FileImport.FileName
  FROM dbo.FileImport left OUTER JOIN dbo.Location 
        ON dbo.FileImport.LocationName = dbo.Location.LocationDesc
  where CAST(dbo.FileImport.CreatedDate AS Date) = '2016-09-14' 
  </code></pre>
  
  <p>There are some older <strong>Locations</strong> that are not used within the Locations table but for now I want to find all <strong>Locations</strong> in the <code>Locations</code> table which don't have a corresponding upload for that day, any help will be appreciated.</p>
  
  <p>Cheers</p>