SELECT e.EmployeeID , e.FirstName , e.LastName , d.Name AS DepartmentName FROM Employees AS e
    INNER JOIN Departments AS d
    ON e.DepartmentID = d.DepartmentID
    ORDER BY e.EmployeeID