title: Select with Inner Join with Multipart Identifier and Having Clause
body: <p>I need to select certain fields for a multipart identifier that has duplicates. </p>
  
  <p>I have the query to grab the duplicates correct.</p>
  
  <pre><code>SELECT   b.MemEmpID, b.LastName, b.FirstName
                 FROM     table1 As b
                 GROUP BY b.MemEmpID, b.LastName, b.FirstName
                 HAVING   Count(*) &gt; 1
  </code></pre>
  
  <p>But after finding the duplicates, I need to grab more information from the same table but only for the multipart identifier that has duplicates. So something like the following. </p>
  
  <p>Can someone please help me with the correct syntax for this?</p>
  
  <pre><code>SELECT a.memempid, a.depkey, a.lastname, a.firstname, a.birthdate, a.memrelation
  FROM   table1 As a
  INNER JOIN(SELECT   b.MemEmpID, b.LastName, b.FirstName
                 FROM     table1 As b
                 GROUP BY b.MemEmpID, b.LastName, b.FirstName
                 HAVING   Count(*) &gt; 1)
  ON b.memempid = a.memempid
  AND b.lastname = a.lastname
  AND b.firstname = a.firstname
  </code></pre>