SELECT teammembers.*, participants.DateFinished
FROM teammembers, participants
WHERE TeamID = '#Client.TeamID#' AND
(participants.ID = teammembers.ParticipantID)
ORDER BY teammembers.PrimaryColor, teammembers.LastName, teammembers.FirstName
ICS-CONNECT ADMINISTRATION - COMPLETED MEMBERS BY PRIMARY COLOR ENERGY