UC知道sql2005中多表查询问题！急！请问如何查询出一个有：学生编号，姓名，班级，科目，分数的表来！
来源：百度知道 编辑：UC知道 时间：2024/05/12 17:58:02
我有5个表：
create table Class
(
classID int not null identity(1,1) primary key,
className varchar(50) not null,
entranceDate datetime not null,
remark varchar(256)
)
insert into Class values('97班','2008-7-15','优秀班级')
insert into Class values('98班','2008-8-15','无')
insert into Class values('99班','2008-9-15','无')
go
create table Student
(
studentID int identity primary key,
studentNO varchar(20) not null,
studentName varchar(50) not null,
studentSex varchar(4) not null,
studentBirthday datetime not null,
classID int references Class(classID) not null,
remark varchar(256)
)
insert into Student values('001','qq,'男','1980-07-24',1,'优秀学生')
insert into Student values('002','ww,'男','1985-11-14',2,'无')
insert into Student values('003&
create table Class
(
classID int not null identity(1,1) primary key,
className varchar(50) not null,
entranceDate datetime not null,
remark varchar(256)
)
insert into Class values('97班','2008-7-15','优秀班级')
insert into Class values('98班','2008-8-15','无')
insert into Class values('99班','2008-9-15','无')
go
create table Student
(
studentID int identity primary key,
studentNO varchar(20) not null,
studentName varchar(50) not null,
studentSex varchar(4) not null,
studentBirthday datetime not null,
classID int references Class(classID) not null,
remark varchar(256)
)
insert into Student values('001','qq,'男','1980-07-24',1,'优秀学生')
insert into Student values('002','ww,'男','1985-11-14',2,'无')
insert into Student values('003&
select
b.studentID,b.studentName,a.className,c.subjectName,e.score--指定显示的列
from Class as a,Student as b,Subject as c,Course as d,Score as e
where a.classID=b.classID and e.studentID=b.studentID and d.subjectID=c.subjectID
and d.classID=a.classID and d.subjectID=c.subjectID and d.courseID=e.courseID and b.studentID=e.studentID
你的studentID明明是int型，为什么插入时间的时候用单引号啊？
55555