I recieve a delimited file whose fields are:
day,slot,subject,room
An example of this file is:
2,1,Mat,R1
3,1,Sci,R6
1,2,Sci,R6
3,2,Mat,R3
1,3,Eng,R2
2,3,Eng,R5
1,4,Mat,R7
3,4,Eng,R9
I need a mysql query that will generate a timetable which looks like:
Day1 Day2 Day3
-------------------------------
1 Mat R1 Sci R6
2 Sci R6 Mat R3
3 Eng R2 Eng R5
4 Mat R7 Eng R9
Any help would be appreciated
sam
**********************************************************************
This message is intended for the addressee named and may contain
privileged information or confidential information or both. If you
are not the intended recipient please delete it and notify the sender.
**********************************************************************
