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 SIAFROM StudentSeminars AS SS RIGHT OUTER JOIN Seminars AS S ON SS.SSeminarSelected = S.SeminarIDWHERE (S.SeminarTerm = 43) AND (SS.SSubmitTerm = 43)GROUP BY S.RoomNumber, SS.SSeminarSelected, S.SeminarDetails, S.Capacity, S.SSort, S.CumCreditsAbove30, S.SIsActiveORDER BY S.SSort