Flag start date does not match
INSERT INTO ProgramParticipation (programID,personID,startDate,districtID)
SELECT ... dTripRelease' AND CS.value = 'N'
LEFT JOIN ProgramParticipation PP ON PP.personID = CS.personID AND PP.startDate ... 'fieldTripRelease' AND CS.value = 'Y'
JOIN ProgramParticipation PP ON PP.personID = CS.personID
JOIN Program P ON... PP
SET userWarning = P.[description]
FROM ProgramParticipation PP
JOIN Program P ON P.programID = PP.programID A