exp36_10.sql

建立信息系学生的视图

/*EXP36_10 查询选修了1号课程的计算机系学生*/
select CS_student.sno,sname
from CS_student,sc
where CS_student.sno = sc.sno AND sc.cno = '1'