帮我看下这个查询语句怎么写,谢谢

[明天是明天]

create table student
(
s# varchar(50)primary key,
sname varchar(50),
sage int,
insert into student values('s0001','夏一','20','男')
insert into student values('s0002','夏二','21','女')
insert into student values('s0003','夏三','22','男')
insert into student values('s0004','夏四','23','女')
insert into student values('s0005','夏五','24','男')
insert into student values('s0006','夏六','25','女')
create table course(
c# varchar(50) primary key,
cname varchar(50),
T# varchar(50))
insert into course values('001','课程一','t0001')
insert into course values('002','课程二','t0004')
insert into course values('003','课程三','t0004')
insert into course values('004','课程四','t0001')
insert into course values('005','课程五','t0003')
insert into course values('006','课程六','t0002')
insert into course values('007','课程七','t0006')
insert into course values('008','课程八','t0006')
create table sc(
s# varchar(50),
c# varchar(50),
scoce float,
primary key(s#,c#))
insert into sc values('s0001','001',60)
insert into sc values('s0001','002',70)
insert into sc values('s0001','003',80)
insert into sc values('s0002','001',61)
insert into sc values('s0002','002',71)
insert into sc values('s0002','003',81)
insert into sc values('s0002','004',91)
insert into sc values('s0002','005',59)

insert into sc values('s0003','001',80)
insert into sc values('s0003','007',81)
insert into sc values('s0004','001',82)
insert into sc values('s0004','008',83)

insert into sc values('s0005','007',81)
insert into sc values('s0005','008',82)

insert into sc values('s0006','006',71)
insert into sc values('s0006','007',81)
insert into sc values('s0006','008',91)

create table teacher(
T# varchar(50)primary key,
tname varchar(50))
insert into teacher values('t0001','李一')
insert into teacher values('t0002','李二')
insert into teacher values('t0003','张一')
insert into teacher values('t0004','吴一')
insert into teacher values('t0005','吴二')
insert into teacher values('t0006','叶平')
insert into teacher values('t0007','叶一')
insert into teacher values('t0008','叶二')

[chuanzhang5687]

http://topic.csdn.net/u/20100517/17/b2ab9d5e-73a2-4f54-a7ec-40a5eabd8621.html?36004看一下这个帖子

[明天是明天]

查询学过“叶平”老师所教的所有课的同学的学号、姓名；

[chtzhking]

[Quote=引用 1 楼 chuanzhang5687 的回复:]

http://topic.csdn.net/u/20100517/17/b2ab9d5e-73a2-4f54-a7ec-40a5eabd8621.html?36004看一下这个帖子
[/Quote]
都以一样的问题,在里面可以找到答案,LZ可以去参考一下

[chuanzhang5687]

select s.,s.sname student s inner join sc c on s.s# = c.s# inner join
course c1 on c.c#= c1.c# inner join teacher t on c1.T# = t.T# 
where t.tname = '叶平'

[勿勿]

建议LZ再发帖的时候搜下以前的帖子。

[--小F--]

这样的题目很多 都是面试题目 呵呵

[明天是明天]

[Quote=引用 1 楼 chuanzhang5687 的回复:]
http://topic.csdn.net/u/20100517/17/b2ab9d5e-73a2-4f54-a7ec-40a5eabd8621.html?36004看一下这个帖子
[/Quote]

--7、查询学过"张三"老师授课的同学的信息
select distinct Student.* from Student , SC , Course , Teacher
where Student.S# = SC.S# and SC.C# = Course.C# and Course.T# = Teacher.T# and Teacher.Tname = N'张三'
order by Student.S#

错误,查询结果为空

[geniuswjt]

实在没耐心看

[明天是明天]

[Quote=引用 4 楼 chuanzhang5687 的回复:]
SQL code

select s.,s.sname student s inner join sc c on s.s# = c.s# inner join
course c1 on c.c#= c1.c# inner join teacher t on c1.T# = t.T#
where t.tname = '叶平'
[/Quote]

错误//

[明天是明天]

[Quote=引用 5 楼 szstephenzhou 的回复:]
建议LZ再发帖的时候搜下以前的帖子。
[/Quote]

关键原来的贴子有错啊

[明天是明天]

可以了,嗯.谢谢大家