sir, i have a sql query related to timetable of institution like.
Select * from(
Select c.classesid,c.code,s.Section,ss.subject,ss.subjectID,w.weekdayid,w.Weekday,Period,p.Employee from timetable t
Inner Join Classes c on c.ClassesID=T.ClassesID
Inner Join Section s on s.sectionid=t.sectionid
Inner Join Subject ss on ss.Subjectid=t.Subjectid
Inner Join Weekday w on w.Weekdayid=t.weekday
Inner Join P_employee p on p.Employeeid=t.teacherID
where t.classesid=20 and t.period=1
) as t
pivot (
max(subject) for Period in ([1]) )as tt
the result of thid query are:
ClassesID classes section subjectid weekdayid weekday teacher [1]
20 XII(Sci) A 1 3 Wed Ayushmaan Khuranna ENGLISH
20 XII(Sci) A 1 4 Thu Ayushmaan Khuranna ENGLISH
20 XII(Sci) A 1 5 Fri Ayushmaan Khuranna ENGLISH
20 XII(Sci) A 1 6 Sat Ayushmaan Khuranna ENGLISH
20 XII(Sci) A 2 1 Mon Monika Rathi HINDI
20 XII(Sci) A 2 2 Tue Monika Rathi HINDI
i need to show result like :-
ClassesID classes section [1]
20 XII(Sci) A [HINDI(Mon-Tus)-ENGLISH(Wed-Sat)/Monika Rathi-aayushmaan khurana]
What I have tried:
i had tried pivot but its not giving a right output that i want.