sc_select

PB做的学生管理系统

select sc.cno,c.cname,sc.score,c.credit
from sc,c
where  sc.sno like :p_sno+'%' and sc.cno=c.cno
order by sc.cno