The problem I am always running into is the First and Last name is always the same person. I cannot figure out the SQL to get the First and Last name of the manager to populate. Essentially I know it is something to do with the join but I am just not expereinced enough to know how to build the right query.
SELECT EmployeeTbl.EmployeeId, ContactInfoTbl.FirstName, ContactInfoTbl.LastName, EmployeeTbl.Status, EmployeeTbl.MgrId, ContactInfoTbl.FirstName, ContactInfoTbl.LastName
FROM ContactInfoTbl INNER JOIN EmployeeTbl ON ContactInfoTbl.PersonID = EmployeeTbl.Employeed