SELECT distinct TeamMemberUserID, FirstName, LastName FROM qmd_territoryMembers ORDER BY LastName, FirstName #qmd_getSalesReps.LastName#, #qmd_getSalesReps.FirstName#