这是我建的三个表
stu(学生表)
sid int
sname varchar(10)
sex bit
birth datetime

sourses(课程表)
soid int
soname varchar(20)

score(成绩表)
sid int             //学号
soid int             //课程号
scores int            //成绩

我想查询一下所有课程都及格的学生信息

我已经想了两天还是写不出来

帮帮啦

网吧没有SQL，我是脑子想的。
select so.soname as '课程名' ,st.sname as '学生名字'
from stu as st join score as sc
on st.sid = sc.sid join sourses as so on
so.soid = sc.soid
group by st.sid
having min(sc.scores)>=60
你试下看行不行，楼下帮忙指正下。

select a.name, b.name,scores from a left join c on a.id=c.id left join b on b.no=c.no  where c.scores >= 60 group by a.id,a.name,b.name,scores

select x.sname,ch.scores, k.soname
from stu x.score ch,sourses k
where x.sid=ch.sid and ch.soid=k.soid and ch.scores>=60
order by scorses

from句的“.”改为“,”

select * from stu
where sid in(
  select sid from score
  GROUP BY sid
  HAVING MIN(scores) >= 60
)

SELECT * FROM stu WHERE sid IN
(SELECT sid FROM (SELECT sid,SUM(soid) FROM score GROUP BY sid WHERE scores>=60 ) WHERE SUM(soid)
=(SELECT SUM(soid) FROM sourses))

就这样一条句子查询语句就搞定

select st.sname as '学生名字'
from stu as st join score as sc
on st.sid = sc.sid join sourses as so on
so.soid = sc.soid
group by st.sid,st.sname
having min(sc.scores)>=60
上面的group by写错了，应该加个st.sname

谢谢
大家了
哎
都怪自己学艺不精啊
看来以后要加倍努力了

select ...
where stu.sid not in (
  select distinct score.sid from score where scores < 60)
and stu.sid in (select distinct score.sid from score)

1、成绩表中任何不及格科目对应的学号，即为有不及格科目的学生；
2、余下的学号中，再把成绩表中没有的学号过滤掉，即过滤掉那些学生表中有但成绩表中没有（可理解为暂未记录成绩）的学生信息，剩下的就是全部都及格的了。
3、选择列表可根据实际需要使用各种连接。