有teacher, student, course, score 四个表
-- 查询有课教师的姓名、职称及其所授的课程名
SELECT teacher.姓名,teacher.职称,course.课名
FROM teacher JOIN course
ON teacher.工号=course.任课教师编号;
有teacher, student, course, score 四个表
-- 查询有课教师的姓名、职称及其所授的课程名
SELECT teacher.姓名,teacher.职称,course.课名
FROM teacher JOIN course
ON teacher.工号=course.任课教师编号;