假设学生表studentsidnaneage课程表coursecidname成绩表scsidcidgrade查询选了中文的学生名
SELECT DISTINCT s.name FROM student s INNER JOIN sc ON s.sid = sc.sid INNER JOIN course c ON sc.cid = c.cid WHERE c.name = '中文'
原文地址: https://www.cveoy.top/t/topic/fg0t 著作权归作者所有。请勿转载和采集!