select as 课程名, score1 as 成绩 form courses,sc,students;
where courses.cid=sc.cid and Sc.sid=students.sid and Sname=thisform.list1.value;
into cursor tmp
这串代码中在列表框中 总是提示出现错误短语或关键字。求帮助啊!!!个人觉得是AND的问题但不知错在什么地方
select as 课程名, score1 as 成绩 from courses,sc,students;
where courses.cid=sc.cid and Sc.sid=students.sid and Sname=allt(thisform.list1.value);
into cursor tmp
from 错为form 可能是楼主发贴的笔误,估计是最后的and Sname字段没有指定表名。
select as 课程名, score1 as 成绩 from courses,sc,students;
where courses.cid=sc.cid and Sc.sid=students.sid and Sname=thisform.list1.value;
into cursor tmp