_______________ ______________ ___________ _______________ ________________ |_tblUsers____| |_tblAnswers__| |_tblAlt__| |_tblQuestion_| |_tblSurvey_____| | userID | | answerAltID | | altID | | questID | | surveyID | | username | | userID | | altText | | questText | | surveyName | |_____________| |_____________| |_questID_| |_surveyID____| |_______________|
I want to make some statistics form these tables.
Rows should be like this:
| questText | altText | count how many answered this | count how many total answered this question | surveyName |
I want to list 1 row for each alternative, and am having a real time creating this query.
Any help would be appreciated!