December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.
and the output looks like this:
SELECT Q.questionID, G.groupID, COALESCE(SUM(R.questionResponse),0) FROM questions Q LEFT JOIN questionResponses R ON Q.questionID = R.questionID LEFT JOIN groups G ON G.groupID = R.groupID WHERE Q.questionID IN ( 244,245,246 ) GROUP BY Q.questionID, G.groupID ORDER BY Q.questionID
Join the community of 500,000 technology professionals and ask your questions.