-- EmployeeSalesSummary_SalesEmps

SELECT      E.BusinessEntityID, 
            C.FirstName + N' ' + C.LastName AS Employee

FROM        HumanResources.Employee E 
INNER JOIN  Sales.SalesPerson       SP ON E.BusinessEntityID = SP.BusinessEntityID 
INNER JOIN  Person.Person           C  ON E.BusinessEntityID = C.BusinessEntityID

ORDER BY    C.LastName, 
            C.FirstName