HI,Can someone tell me what is wrong with this query, please? It should be simple, but I have something wrong. For example, it is bringing up attendance for JoeSmith in the small group, 10th Grade Boys. However, he is now in 12th Grade not 10th. ??
SELECT COUNT(core_occurrence_attendance.person_id) AS [Number Attended], core_person.nick_name, core_person.last_name, smgp_group.group_name,
MAX(core_occurrence.occurrence_start_time) AS [Date Last Attended], smgp_group_occurrence.group_id
FROM core_occurrence_attendance INNER JOIN
core_person ON core_occurrence_attendance.person_id = core_person.person_id INNER JOIN
smgp_group_occurrence ON core_occurrence_attendance.occurrence_id = smgp_group_occurrence.occurrence_id INNER JOIN
smgp_group ON smgp_group_occurrence.group_id = smgp_group.group_id INNER JOIN
core_occurrence ON smgp_group_occurrence.occurrence_id = core_occurrence.occurrence_id
GROUP BY core_person.nick_name, core_person.last_name, smgp_group.group_name, smgp_group.active, smgp_group_occurrence.group_id
HAVING (smgp_group.active = 1)
ORDER BY smgp_group.group_name