title: Join returns multiple results
body: <p>Long night, and I am struggling to fix this problem. </p>
  
  <p>I have a query which returns multiple rows with the same results.</p>
  
  <pre><code>SELECT        apf_Members.AppsTitle, apf_Members.AppsFirstName, apf_Members.AppsLastName, vw_apf_MemStat.MemberID, vw_apf_MemStat.DNNUserID, 
                           vw_apf_MemStat.MemStat_LapsedMember, vw_apf_MemStat.MemStat_CurrentMember, vw_apf_MemStat.MemStat_Unrenewed, 
                           apf_Members.MemberID AS Member, apf_Members.PostalCompany AS Company, apf_Members.AppsFirstName AS FirstName, 
                           apf_Members.AppsLastName AS LastName, apf_Members.AppsBirthDate AS DOB, apf_Members.PostalState AS State 
  
  FROM            apf_Members INNER JOIN
                           vw_apf_MemStat ON apf_Members.MemberID = vw_apf_MemStat.MemberID INNER JOIN
                           vw_apf_AttributesConditions ON apf_Members.MemberID = vw_apf_AttributesConditions.MemberID
  
  
  WHERE        (vw_apf_MemStat.MemStat_CurrentMember &lt;&gt; - 1) AND (vw_apf_AttributesConditions.AttributeID = 7)
  ORDER BY apf_Members.AppsLastName, State, apf_Members.MailOption
  </code></pre>
  
  <p>How do I stop duplicate rows?  The columns appear to be exactly the same for each duplicate row, so they are definitely duplicates.</p>
  
  <p>I am assuming it is the 2x inner joins, but I cant seem to fix it. </p>
  
  <p>Thanks Guys,</p>
  
  <p>-R</p>