SQL Join query, getting ManagerName
- by user279521
I have an tblEmployeeProfile & a tblPersonnel. tblPersonnel is an HR table, that consists of all employees in the company; tblEmployeeProfile contains details about an employee's position.
tblPersonnel.PersonnelID
tblPersonnel.FirstName
tblPersonnel.MiddleName
tblPersonnel.LastName
tblPersonnel.PhoneNumber
tblPersonnel.Email
tblEmployeeProfile.EmployeeID
tblEmployeeProfile.ManagerID
tblEmployeeProfile.DepartmentID
tblEmployeeProfile.JobCategoryID
tblEmployeeProfile.SalaryID
I want to return a record with the following fields:
EmployeeID, FirstName, MiddleName, LastName, Email, ManagerFullName
where EmployeeID = @EmployeeID
*tblEmployeeProfile.ManagerID = tblPersonnel.PersonnelID*
I can't seem to get the query correct for getting the ManagerFullName