p

来自「PB做的学生管理系统」· 代码 · 共 4 行

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