Inner Joins between Subsets of the Same Table
You are trying to do self join which is perfectly fine in this case. You can create another identical table and rename it, but is not necessary.
You should write something like this:

    SELECT m.employeeid AS ManId, m.empfirstname AS ManFirstName,     
    m.emplastname AS ManLastName,
    s.employeeid AS StaffId, s.empfirstname AS StaffFirstName,
    s.emplastname AS StaffLastName
    FROM Employee s
    JOIN Employee m
    ON s.ReportsTo = m.employeeid