title: JOINING Same Table gives duplicate information
body: <p>I want to join the same table to get some information. </p>
  
  <p>I have a <strong>Person Table</strong> </p>
  
  <pre><code>PersonId, FirstName, LastName, Address
  </code></pre>
  
  <p>Also <strong>Patient Table</strong></p>
  
  <blockquote>
    <p>PatientId, PersonId, ResponsiblePersonId</p>
  </blockquote>
  
  <p>Below is the query i tried to get Patient's FirstName, Last Name also the Responsible Person FirstName, Last Name. For this I JOINED Person table once again to get Responsible Persons First, Last names. </p>
  
  <p><strong>But I got many duplicate records.</strong></p>
  
  <pre><code>SELECT   PAT.PatientId
  
          ,PER.PersonNumber
          ,PER.FirstName
          ,PER.LastName
          ,RES_PER.FirstName AS ResFirstName
          ,RES_PER.LastName AS ResLastName
          ,PER.Address                
  
  FROM        dbo.Patient AS PAT
  INNER JOIN  dbo.Person AS PER
      ON  PAT.PersonId = PER.PersonId
  INNER JOIN  dbo.Person AS RES_PER
      ON  PAT.ResponsiblePersonId = PER.PersonId
  </code></pre>
  
  <p>How can i get Patient FirstName, LastName &amp; Responsible Person's First Name, Last Name for the patient record?</p>