select *
from (
SELECT ...
FROM tblquestions
) questions,
(
SELECT ...
FROM
tblquestions
INNER JOIN
tblanswersets USING (answerSetID)
INNER JOIN
tblanswers USING (answerID)
) answers,
(
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
) counts
then you join your 3 sub queries down here..
On 3/20/07, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> Jochem,
>
> Do all these individual queries go into one query, separated with a ; ?
>
> Thanks,
> Will
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273110
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
