SELECT student.[学号(sno)], student.[姓名(sname)], student.[性别(sex)], student.[年龄(age)], student.[所在系(dept)], sc.cno, sc.grade FROM student, sc WHERE student.[学号(sno)]=sc.sno;
select jiben,xuanke from biao where student="yixuanxingming";