4.查询教员当天的空闲.sql

guan yu pai ke xi tong de ruan jian

SELECT [Name],W.ClassCode, W.TimeId, W.WeekId, W.RoomId 
FROM Teachers
INNER JOIN Teachings AS T
ON Teachers.TeacherId = T.TeacherId 

INNER JOIN WeekCourses AS W
ON W.ClassCode = T.ClassCode

WHERE T.ClassCode = 'S2T08' AND W.TimeId = 2 AND WeekId = 2