SELECT Subjects.SubName,DayTable.DayName FROM ClassRoom INNER JOIN Cst ON ClassRoom.ClassId = Cst.ClassId INNER JOIN newTimeTable ON Cst.CstId = newTimeTable.CstId INNER JOIN ClassHours ON newTimeTable.HourId = ClassHours.HourId INNER JOIN Subjects ON Cst.SubjectId = Subjects.SubjectId INNER JOIN DayTable ON newTimeTable.DayId = DayTable.DayId where HourName='5th Hour' and ClassName='1st Class' ORDER BY DayTable.DayName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)