PP.programID
WHERE endDate IS NULL
--Copy Flag Description to User Warning
UPDATE PP
SET userWarning = P.[description]
FROM ProgramParticipation PP
JOIN Program P ON P.p... D P.code = 'FIELDTRIP'
WHERE PP.userWarning <> P.[description] OR PP.userWarning IS NULL
</code>
====== No Medi... = PP.programID
WHERE endDate IS NULL
--Copy Flag Description to User Warning
UPDATE PP
SET userWarning = P.[de