create table cla
(
cid int primary key identity(1,1),
cname varchar(20)
)create table stu
(
sid int primary key identity(1,1),
sname varchar(20),
cid int references cla(cid) //cla 外键
)create table
(
mid in primary key identity(1,1),
sid int references stu(sid) ,//stu 外键
maths varchar(20),//代数
chemistry varchar(20)//化学
)怎么样查找 班级名称 姓名 代数成绩 化学成绩
(
cid int primary key identity(1,1),
cname varchar(20)
)create table stu
(
sid int primary key identity(1,1),
sname varchar(20),
cid int references cla(cid) //cla 外键
)create table
(
mid in primary key identity(1,1),
sid int references stu(sid) ,//stu 外键
maths varchar(20),//代数
chemistry varchar(20)//化学
)怎么样查找 班级名称 姓名 代数成绩 化学成绩
FROM cla AS A
JOIN stu AS B
ON A.cid = B.cid
JOIN AS C
ON B.sid = C.sid
FROM cla ,stu,
where cla.cid=stu.cid and stu.sid=.sid
select cname,sname,maths,chemistry from cla a ,stu b , c
where a.cid=b.cid and b.sid=c.sid
where a.cid=b.cid and b.sid=c.sid