On 4/15/05, Mills, Andy R. (Regency) <[EMAIL PROTECTED]> wrote: > > > SELECT > Question1, Question2, Question3, Question4, Question5, Question6, > Question7, Question8, > AVG(Question1) AS QAvg1, AVG(Question2) AS QAvg2, AVG(Question3) AS > QAvg3, AVG(Question4) AS QAvg4, AVG(Question5) AS QAvg5 > FROM > tSurvey > GROUP BY > Question1, Question2, Question3, Question4, Question5, Question6, > Question7, Question8 > > The problem is: Question 6, Question7, Question8 are TEXT fields, and not > able to be grouped. However: If I don't include them in the group by: I > get an error because they are not part of an aggragate function. What > would > I need to do to get this Query to work?
Wouldn't the query be: SELECT AVG(Question1) AS QAvg1, AVG(Question2) AS QAvg2, AVG(Question3) AS QAvg3, AVG(Question4) AS QAvg4, AVG(Question5 aS QAvg5, Question6, Question7, Question8 FROM tSurvey GROUP BY Question6, Question7, Question8 [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
