title: Pseudo to SQL? All Records where FirstName & LastName Is duplicated but City is different?
body: <p>I need to find all records that the FIRSTNAME is a duplicate and the LASTNAME is a duplicate but the city is different for the records where the names are duplicate.</p>
  
  <p>So my data looks like this:</p>
  
  <pre><code>FirstName    LastName    CustomerFileLocation          City
  ----------------------------------------------------------------------
     Joe        Smith         c:\file1\File1.txt         Dallas
     Joe        Jones         c:\File2\File1.txt         New York
     Joe        Smith         c:\File3\File1.txt         New Mexico City
     Harry      Smith         c:\File4\File1.txt         Boca Raton
     Joe        Smith         c:\File3\File1.txt         Dallas
     Michael    Smith         c:\File1\File1.txt         Dallas
  </code></pre>
  
  <p>I want the query to return </p>
  
  <pre><code>   Joe        Smith         c:\file1\File1.txt         Dallas
     Joe        Smith         c:\File3\File1.txt         New Mexico City
  </code></pre>
  
  <p>I wrote the following to find the matching FirstName and LastName.  But I am not sure how to say "and City doesn't match"</p>
  
  <pre><code>SELECT        
     dbo.TblFileCache.FirstName, dbo.TblFileCache.LastName, 
     dbo.TblFileCache.ClaimFilePath, dbo.TblFileCache.Skip
  FROM
     dbo.TblFileCache 
  INNER JOIN
     (SELECT        
         FirstName, LastName, COUNT(*) AS CountOf
      FROM 
         dbo.TblFileCache AS tblFileCache_1
      GROUP BY 
         FirstName, LastName 
      HAVING         
         (COUNT(*) &gt; 1)) AS dt ON dbo.TblFileCache.FirstName = dt.FirstName 
                               AND dbo.TblFileCache.LastName = dt.LastName
  WHERE        
      (dbo.TblFileCache.Skip = 0)
  ORDER BY 
      dbo.TblFileCache.FirstName, dbo.TblFileCache.LastName
  </code></pre>