mySQL SQL Conversion
| From: | Logan McKinley | Date: | Mon, 16 Feb 2004 16:21:09 +0000 |
| Subject: | mySQL SQL Conversion | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-177822@lists.php.net to get a copy of this message | ||
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