javierpdx
asked on
tsql show record for zero count value
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER