多表查找

比较经典

一个课程学分表

C(cno, cname, ccredit)

一个学生选课表

SC(sno, cno, grade)

select sno from sc,c where sc.cno=c.sno and sc.grade>=60 group by sno having sum(credit)>=32;