I have a table contaning subject marks of different class in this format.
Id Subject ProjMks ProjStatus TheoryMks TheoryStatus
1 Engish 18 p 40 p
1 Math 18 p 62 p
Now i want to display in following format :
Id EnglishProjectMks EnglishProjectSts EnglishTheoryMks EnglishTheorySts
1 18 p 40 p
MathsProjectMks MathsProjectSts MathsTheoryMks MathsTheorySts
18 p 62 p
Plz suggest me some query by which i can achieve this.