Your question, your audience. Choose who sees your identity—and your question—with question security.
I appreciate any assistance.
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
Join the community of 500,000 technology professionals and ask your questions.