• Let me be clearer.

    The first table is just the employee table. the second table is the relationship between the people in the first table. What I would like to do is be able to query the database so that I could get the name of the supervisor or employee of the manager whose id is 1. How can I join these two tables to reflect this.