select a.sname,b.cname,c.degreefrom student a,course b,score c where a.sno=c.sno and b.cno=c.cno
或
select a.sname,b.cname,c.degreefrom student a inner join score c on a.sno=c.snoinner join course b on b.cno=c.cno