150分求教VFP SQL语句
xymdk 2003-10-17 08:42:47 有3个表:
s(xh,xm)(学号\姓名)
c(kch,khm,ls)(课程号\课程名\老师)
sc(xh,kch,cj)(学号\课程好\成绩)
现在要查询的是:选修全部课程的学生姓名.
select s.xm
from s
where not exists
(sele *
from sc
where not exists
(sele *
from c
where sc.xh=s.xh and sc.kch=c.kch));
VFP6中写此语句,说嵌套太深,有简单的语句实现或怎么实现?