(18)查询所有选课的学生的详细信息。
select distinct Students.Sno,Sname,Semail,Scredit,Ssex,Cname,Courses.Cno,Score
from Students,Courses,Reports
where Students.Sno=Reports.Sno and Reports.Score is not null
(18)查询所有选课的学生的详细信息。
select distinct Students.Sno,Sname,Semail,Scredit,Ssex,Cname,Courses.Cno,Score
from Students,Courses,Reports
where Students.Sno=Reports.Sno and Reports.Score is not null