General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thank you Naomi for your help, I will try to explain.
I have a table called report which include the following structure
student_id
name
subject
mark
a sample of the data
ID NAME MARK SUBJECT
1 AAA 11 MATH
1 AAA 12 BIOLOGY
1 AAA 12 ENGLISH
1 AAA 14 CIVIC
1 AAA 15 HISTORY
2 BBB 7 CHEMSTRY
2 BBB 2 MATH
2 BBB 22 BIOLOGY
2 BBB 21 MATH
3 CCC 31 MATH
3 CCC 34 CIVIC
3 CCC 35 HISTORY
3 CCC 37 ECONOMIC
THIS TABLE SHOULD BE CONVERTED TO ANOTHER TABLE AS FOLLOW
STUDENT ID NAME SUBJECT 1 SUBJECT 2 SUBJECT 3 SUBJECT 4 SUBJECT 5
1 AAA MATH BIOLOGY SPANISH CIVIC HISTORY
2 BBB MATH BIOLOGY
this is where exactly I stack since 10 days, if only I can create a report horizentaly from a vertical table my problem is solved.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only