您需要在table_courses和table_student_course表上使用JOIN,然后在cource_name上应用Order By以按课程名称进行排序.选择特定学生时,将Where子句应用为过滤器.
SELECT
t.course_name,
tsc.date_taken
FROM
table_courses t INNER JOIN table_student_course tsc
ON t.ID = tsc.course_ID
WHERE
tsc.student_ID = 1
ORDER BY
t.course_name
如果您还想从查询中获取学生详细信息,那么您需要加入以下3个表格,
SELECT s.firstname, s.lastname, c.course_name, sc.date_taken
FROM table_courses c
INNER JOIN table_student_course sc ON c.ID = sc.course_ID
INNER JOIN table_student s ON sc.student_ID = s.ID
WHERE sc.student_ID = 1
ORDER BY c.course_name