95001查询程序.prg

此为一个学生信息系统,是本人自已做的,希望能和大家一起交流!

select sno,sname  from  student表; 
where  sno in;
(select sno from sc where cno  in;
(select cno from  course表 where cname='信息系统'));