Hi there,
Please I know there must be a simple answer, I want to allow
members to join committees, so ONE user can have have MULTIPLE
committees.
i have set it to look through the committees and put a
checkbox beside the ones that a member has selected. It works fine,
BUT it is showing all members, rather an a specific one. I have
tried WHERE memberID = 'member123" but that only shows the
committees that they have already selected.
So i want to loop through the committees and only show where
ONE member is currently selected.
Here is my SQL
SELECT
contactidentifier.identifierID,
contactidentifier.identifierText,
contactidentifier_list.contactIdentifier,
contactidentifier_list.identifierListID
FROM
contactidentifier
LEFT JOIN
contactidentifier_list
ON
contactidentifier.identifierID =
contactidentifier_list.contactIdentifier;
Any help would be most grateful