select a.* from score s INNER JOIN
( select st.* from student st
INNER JOIN score sc
on st.id = sc.stu_id
where sc.c_name = '计算机'
) a on s.stu_id = a.id where s.c_name = '英语';
SQL中查询同时参加计算机和英语考试的学生的信息学生表student成绩表 score主要使用的是显示内连接查询和子查询,关键词:inner join on .select a.* from score s INNER JOIN( select st.* from student st INNER JOIN score sc on st.id = sc.stu_i...