SELECT
student.sno,
sname
FROM
student,
course,
sc
WHERE
student.sno = sc.sno
AND course.cno = sc.cno
AND course.cname = '信息系统'
SELECT
student.sno,
sname
FROM
student,
course,
sc
WHERE
student.sno = sc.sno
AND course.cno = sc.cno
AND course.cname = '信息系统'