title: SELECT or JOIN using two tables with similar columns
body: <h1>Brief Overviw and Relationship Info</h1>
  <p>One Mentor may mentor several Mentees in a 1:N relationship which is optional on both ends, therefore there may be managers who don't mentor any other managers and also managers who are not mentored by another manager. Both Mentors and Mentees are represented by their respective Number which is also their Manager Number from the Manager table.</p>
  <h1>Given Schema</h1>
  <p>The Employee table has the following columns:</p>
  <ul>
  <li>Employee_Number</li>
  <li>Name</li>
  <li>Home Address</li>
  <li>Telephone Number</li>
  </ul>
  <p>The Manager table contains:</p>
  <ul>
  <li>Manager_Number</li>
  <li>Employee_Number (linked with foreign key to Employee table)</li>
  </ul>
  <p>The Mentor table contains:</p>
  <ul>
  <li>Mentee_Number (linked with foreign key to Manager table[Manager_Number])</li>
  <li>Mentor_Number (also linked with foreign key to Manager table[Manager_Number])</li>
  </ul>
  <h1>What's required and what I tried</h1>
  <p>I am trying to do a JOIN so that I can see following columns:</p>
  <ul>
  <li>Mentor's Manager Number</li>
  <li>Mentor's Name</li>
  <li>Mentee's Manager Number</li>
  <li>Mentee's Name</li>
  </ul>
  <p>I have the following join statement, which does not seem to work and I am unsure why:</p>
  <pre><code>SELECT
    man.manager_number,
    man.employee_number AS mentor_employee,
    emp.name AS mentor_name,
    man2.employee_number AS mentee_employee,
    emp2.name AS mentee_name
  FROM 
    manager man
  INNER JOIN
    employee emp
  ON
    emp.employee_number = man.employee_number 
  INNER JOIN
    mentor men
  ON
    man.manager_number= men.mentor_number
  INNER JOIN
    employee emp2
  ON
   emp2.employee_number = man2.employee_number 
  INNER JOIN
    mentor men
  ON
    man.manager_number= men.mentee_number;
  </code></pre>
  <p>Any help would be greatly appreciated!</p>