Another Query Problem

[TWTCommish]

Yup...I just keep on screwing up. Any ideas on what's wrong with this one?

SELECT q.quizid, q.quiztitle, q.description, r.totalcorrect,
SUM(r.totalcorrect) as correct, COUNT(r.resultid) AS total
FROM quizzes q, results r WHERE r.quiz_id = q.quizid AND q.approve
= 'Yes' AND r.complete = 'Yes'

I was also trying to use AVG(), and perhaps a GROUP BY (or at least ORDER BY) statement in there, too, but I can't even get THIS to work, so I'll save that part for later.

[ahajdar]

What is the error? Syntax seems OK assuming that your have all of those columns in the tables that are named the same way.

Suggestion...build your query step by step, don't just write the whole thing at once. Start with one table and one comparison, then add second table and another comparison, then do your join.

Good luck!

[MattR]

You cannot use AVG without a GROUP BY clause.

[MattR]

Double-tap!

[freddydoesphp]

And I just erased my message that said that Matt, I reread his post and saw SUM() and didn't even think to rea dthe words where he did indeed use AVG().

[TWTCommish]

Nevermind, I found some other error in my logic...d'oh! Thanks anyway, guys.