三张表
STUDENT:STUDENTID,NAME
COURSE:COURSEID,NAME
COURSESELECT:COURSEID,STUDENTID
表示学生选的课程如何选出既选了语文又选了数学的学生名单谢谢!!
STUDENT:STUDENTID,NAME
COURSE:COURSEID,NAME
COURSESELECT:COURSEID,STUDENTID
表示学生选的课程如何选出既选了语文又选了数学的学生名单谢谢!!
调试欢乐多
in(select studentid from courseselect where courseid
in (select courseid from course where name='语文'and name='数学'));
from COURSESELECT a,COURSESELECT b,STUDENT c
where a.STUDENTID=b.STUDENTID
and a.STUDENTID=c.STUDENTID
and a.COURSEID=(select COURSEID from COURSE where NAME='语文')
and b.COURSEID=(select COURSEID from COURSE where NAME='数学')