thisform.grid1.recordsource=";
select chengji.学号,xuesheng.姓名;
from xuesheng join chengji on xuesheng.学号 = chengji.学号;
where chengji.数学 > (select avg(数学) from chengji);
and chengji.英语 > (select avg(英语) from chengji);
and chengji.信息技术 > (select avg(信息技术) from chengji);
order by chengji.学号 desc“
这样在表单执行命令为什么不可以

相反去掉thisform.grid1.recordsource=";” 变成
select chengji.学号,xuesheng.姓名;
from xuesheng join chengji on xuesheng.学号 = chengji.学号;
where chengji.数学 > (select avg(数学) from chengji);
and chengji.英语 > (select avg(英语) from chengji);
and chengji.信息技术 > (select avg(信息技术) from chengji);
order by chengji.学号 desc
就可以了

把条件第三条去掉 and chengji.信息技术 > (select avg(信息技术) from chengji); 也可以成功

thisform.grid1.recordsource=";
select chengji.学号,xuesheng.姓名;
from xuesheng join chengji on xuesheng.学号 = chengji.学号;
where chengji.数学 > (select avg(数学) from chengji);
and chengji.英语 > (select avg(英语) from chengji);
order by chengji.学号 desc“
两个and 这么久不可以了

为什么 啊 就是不懂

图片来自：lygcw9602的百度相册