Subquery, Can I Do Two In One Proc?

I have this stored procedure which is supposed to pull the totals of all the responses (Yes) and (No). I created a subquery and was able to get the total of the totals for all the yes's for each Question and date. which is exactly what i want. Only problem is, somewhere in the code, it is now not showing the No's . And i want it to show the no' s too. I also wanted to add another subquery that grabs all the No's and group them by Question and date (just like i did for the yes's). I pretty much want the report to show the total number of yes and no responses to each question for each date. My stored procedure right now only shows the totals for Yes's. Please help.



Code Snippet


SELECT


Qry_Questions.Question,
Qry_Questions.Date,
Qry_Questions.response,
B.TotalYes

FROM Qry_Questions
INNER JOIN Qry_Sales_Group
ON dbo.Qry_Questions.sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.Qry_Sales_Group.SalesPerson_Purchaser_Code
INNER JOIN ( Select COUNT(qq.response)as TotalYes, Question, Date , response
FROM Qry_Questions qq
Where qq.response='Yes'
GROUP by qq.[Question] , qq.Date,qq.response ) B
ON Qry_Questions.Date = B.Date AND
Qry_Questions.Question =B.Question and
Qry_Questions.response=B.response
WHERE Qry_Questions.[Response Type]='YesNo'
Group by Qry_Questions.question, Qry_Questions.Date, Qry_questions.Response,B.TotalYes
order by Qry_Questions.Question