mysql - mysql 子查询的问题

Question

我对如何进行 SQL 查询感到困惑，该查询将显示正在学习特定讲师教授的科目的学生详细信息。

有 5 个表是我的数据库。

主题(subjectCode、subjectName、creditHour、studyMode)

学生(stdID，stdName`)

讲师(lecID，lecName`)

讲师主题(lec_subID、lec_userID、subjectID)

学生主题(std_subID、student_userID、subjectCode)

Answer 1

您需要应用 join 和 WHERE 子句来获取所需的数据。

SELECT DISTINCT 
    Sturent.stdName as StudentName, 
    Subject.subjectName as SubjectName, 
    Lecturer.lecName as LecturerName, 
    Subject.creditHour, 
    Subject.studyMode  
FROM 
  Student JOIN Student-subject 
   ON student.stdID= Student-subject.student_userID
  JOIN Subject 
   ON Student-subject.subjectCode = subject.subjectCode
  JOIN Lecturer-subject 
   ON Lecturer-subject.subjectID = subject.subjectCode
  JOIN Lecturer 
   ON Lecturer-subject.lec_userID = lectrer.lecID
 WHERE
    Lecturer.lecName = 'some lecturer name'