List:General Discussion« Previous MessageNext Message »
From:Logan McKinley Date:February 16 2004 6:01pm
Subject:mySQL SQL Conversion
View as plain text  
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



Thread
mySQL SQL ConversionLogan McKinley16 Feb
Re: mySQL SQL ConversionVictoria Reznichenko17 Feb