title: How to: JOIN one column from one table to 2 columns in the other table?
body: <p>First post... although I have referenced this site many times.  I have one table that contains two columns that use the employee ID#'s.  The other table has the employee's name and employee ID#. I am trying to get the employee name to come back for both columns in one table.</p>
  
  <p><code>Employee</code> table contains <code>EmployeeName</code> and <code>EmployeeID</code>
  Jobs table contains employee # in the <code>JobSuperID</code> column and employee # in the <code>JobManID</code> column</p>
  
  <pre><code>Select EmployeeName
  FROM [DBex].[dbo].[JobStatus] 
  Right JOIN [DBex].[dbo].[Employees] 
    ON [DBex].[dbo].[Employees].EmployeeID = [DBex].[dbo].[Jobs].JobSuperID
  Right JOIN [DBex].[dbo].[Employees] 
    ON  [DBex].[dbo].[Employees].EmployeeID = [DBex].[dbo].[Jobs].JobAcctManID
  </code></pre>
  
  <p>I have seen references to using <code>AS</code> but have not been able to get the syntax right. Also if I am only selecting <code>EmployeeName</code> how do I display both columns? Where am I going wrong here?</p>