Re: mySQL SQL Conversion

2004-02-17 Thread Victoria Reznichenko
"Logan McKinley" <[EMAIL PROTECTED]> 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 e

mySQL SQL Conversion

2004-02-16 Thread Logan McKinley
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)