I have some problem
My Sql table look like this..
Session Student Id Subject MarksType Marks
2013-2014 S00001 Math FA1 50
2013-2014 S00001 Hindi FA1 60
Session Student Id Subject MarksType Marks
2013-2014 S00001 Math FA1 50
2013-2014 S00001 Hindi FA1 60
2013-2014 S00001 English FA1 62
In Access 2007
TRANSFORM Avg(Marks) as Mrk SELECT Subject FROM StudentsMarks WHERE Session='2013-2014' AND Student Id='S00001' GROUP BY Session_,Student Id, Subject PIVOT MarksType In (FA1, FA2)
How to use same query in Sql?