Hi I need immediate help guyssssss. The scenario is like this:
I have 3 tables: subject,class and mark which have details subjectid,subject in subject; classid, classname in class; markid, classid,subjectid,marks in mark.
I want to display the details in a form like class forms the header text vertically, subject horizontally and marks corresponding to (class,subject).
I have attached a screenshot of the required output...i tried lots of ways..not working..
Class/Subject Class 5 Class 6 Class 7
abcd 66 62 56 Delete
efg 77 77 55 Delete
rst 56 87 98 Delete