Any one to help me translate this query into MySQL or get any equivalet query for pivot table --- TRANSFORM First(examresult.Grade) AS FirstOfGrade SELECT examresult.RegNo, First(examresult.Grade) AS [Total Of Grade] FROM examresult GROUP BY examresult.RegNo PIVOT examresult.CourseCode; --- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
