Comnbining multiple rows into one row

[Equalizer700]

We have a table that has school IDs, grades (1-12), subjects (reading, math) and scores (integers). There is one row in the table per subject/grade combination. For instance, reading grade 2 will be one row, reading grade 3 is another row, etc. There is a full set of subject/grade rows for each school, so there are 24 rows per school (12 reading, 12 math). We need to run a query that combines all the subject/grade/scores into one row per school, so the result row would have school_ID, reading_grade_1_score, math_grade_1_score, reading_grade_2_score, math_grade2_score, etc.

All the rows for one school have the same school_ID.

Can someone point me in the direction of how to accomplish this? Help will be greatly appreciated!

[Rixxe]

Sounds like you need concatenation, this link might help, keep searching for the answer. Sure someones done it.
http://stackoverflow.com/questions/5...ditions-needed

Good Luck