S.date AS DATE)
CROSS JOIN (SELECT programID FROM Program WHERE code = 'FIELDTRIP') P
CROSS JOIN (SELECT di... articipation PP ON PP.personID = CS.personID
JOIN Program P ON P.code = 'FIELDTRIP' AND P.programID = PP.pr... P.[description]
FROM ProgramParticipation PP
JOIN Program P ON P.programID = PP.programID AND P.code = 'FIE... S.date AS date)
CROSS JOIN (SELECT programID FROM Program WHERE code = 'MEDIA') P
CROSS JOIN (SELECT distri