Will Tomlinson wrote:
>
> Show me a list of questions
SELECT ...
FROM tblquestions
> all possible evaluation answers for each question
SELECT ...
FROM
tblquestions
INNER JOIN
tblanswersets USING (answerSetID)
INNER JOIN
tblanswers USING (answerID)
> and a total of each answer chosen.
SELECT
A.answerID,
COUNT(EAR.answerID)
FROM
tblquestions Q
INNER JOIN
tblanswersets ARS USING (answerSetID)
INNER JOIN
tblanswers A USING (answerSetID)
LEFT JOIN
tblevalanswersresults EAR USING (answerID)
GROUP BY
A.answerID
> Does this make sense?
If you join this to some table with instructors you should get what you
need.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
