this is a php message board.
Logan McKinley wrote:
I am using MySQL (4.0.17) and am getting errors with the following SQL statement originally writen for MS products.
SELECT survey_questions.Question_ID, First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line returns errors i believe it is the AS Avg(survey_responses.Response) AS AvgOfResponse, Count(survey_responses.Response) AS CountOfResponse, survey_questions.survey_num
FROM survey_questions INNER JOIN survey_responses ON survey_questions.Question_ID = survey_responses.QuestionID
GROUP BY survey_questions.Question_ID, survey_questions.survey_num
HAVING (((Avg(survey_responses.Response))<>-1) AND ((survey_questions.survey_num)=0));
Thanks in advance, ~Logan
-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
