return 0 with sql query instead of nothing
- by user1202606
How do I return a 0 with as Responses with the PossibleAnswerText if count is 0? Right now it won't return anything.
select
COUNT(sr.Id) AS 'Responses', qpa.PossibleAnswerText
from
CaresPlusParticipantSurvey.QuestionPossibleAnswer as qpa
join
CaresPlusParticipantSurvey.SurveyResponse as sr on sr.QuestionPossibleAnswerId = qpa.Id
where
sr.QuestionPossibleAnswerId = 116
GROUP BY
qpa.PossibleAnswerText
