title: how can i avoid multiple joins on the same table?
body: <p>I would like to know how I can avoid all of these left joins with just 1 left join, or anything else that would require less joins?</p>
  
  <pre><code>select colums
    FROM [SectionAUnresolved] a
    left join sectionanotmarkedcounts sdirector
    on a.director=sdirector.employee
  
    left join sectionanotmarkedcounts s_rm
    on a.rm=s_rm.employee
  
    left join sectionanotmarkedcounts s_rep
    on a.rep=s_rep.employee
  
    left join sectionanotmarkedcounts s_css
    on a.css=s_css.employee
  
    left join sectionanotmarkedcounts s_Css2
    on a.css2=s_Css2.employee
  </code></pre>
  
  <p>thank you for your guidance!</p>