SELECT DISTINCT(participants.ID) AS ID, participants.FirstName, participants.LastName,
participants.Email,
participants.PrimaryColor, participants.ColorAssigned, participants.GroupAssigned,
participant_module_links.ModuleID,
modules.ModuleName
FROM participants, participant_module_links, modules
WHERE participants.ProjectID = '#Client.ProjectID#' AND
participant_module_links.ParticipantID = participants.ID AND
modules.ID = participant_module_links.ModuleID
ORDER BY modules.ModuleName,participants.LastName, participants.FirstName
SELECT DISTINCT(participants.ID) AS ID
FROM participants, participant_module_links
WHERE participants.ProjectID = '#Client.ProjectID#' AND
participant_module_links.ParticipantID = participants.ID
ICS-CONNECT ADMINISTRATION - PARTICIPANTS WITH MODULES BY MODULE NAME