I've been trying to change my join to show all Seminars, even if it has a zero count but have not been able to get this so far. It currently only shows records in which Selected Seminars have at least one record.
SELECT SS.SSeminarSelected SSS, COUNT(SS.SSeminarID) AS 'Seminar Count', S.RoomNumber SRN, S.Capacity Cap, S.SeminarDetails SSD, S.CumCreditsAbove30 SCCA, S.SIsActive SIA
FROM StudentSeminars AS SS RIGHT OUTER JOIN
Seminars AS S ON SS.SSeminarSelected = S.SeminarID
WHERE (S.SeminarTerm = 43) AND (SS.SSubmitTerm = 43)
GROUP BY S.RoomNumber, SS.SSeminarSelected, S.SeminarDetails, S.Capacity, S.SSort, S.CumCreditsAbove30, S.SIsActive
ORDER BY S.SSort
I appreciate any assistance.