-- 查询8 获取某个课程的所有教师-- 假设我们要查询CourseID为2的课程的所有教师SELECT csCourseName teTeacherName
FROM Course cs JOIN CourseTeacher ct ON cs.CourseID = ct.CourseID JOIN Teacher te ON ct.TeacherID = te.TeacherID WHERE cs.CourseID = 2
原文地址: https://www.cveoy.top/t/topic/hCRi 著作权归作者所有。请勿转载和采集!