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