班级课程设置.sql

guan yu pai ke xi tong de ruan jian

SELECT C.ClassCode, C.SectionCode, C.TypeCode, 
		C.ProductId, C.ClassStatus, T.TeacherId, T.CourseId
FROM Classes AS C 
INNER JOIN Teachings AS T 
ON C.ClassCode = T.ClassCode
WHERE C.TypeCode = 'T' AND C.ClassStatus = 0 OR C.ClassStatus = 2