Access查询语句

zhrs98

查询序号在“TZ03070020”以后的“基本工资”和“奖金”均在2000元以上的员工列表，结果表中包括序号、姓名、基本工资、奖金。如何用Access查询来实现

LAOMALIN

access并没有先后顺序，如果改成时间字段或序号之类的就比较容易，它不象EXCEL的记录顺序

zhrs98

我把问题和Access文档放到附件中，谢谢先

vincent_li

SELECT student.sno AS 学号, student.name AS 姓名, score.score AS 哲学成绩, score_1.score AS 经济学基础成绩
FROM course AS course_1 INNER JOIN (score AS score_1 INNER JOIN (course INNER JOIN (student INNER JOIN score ON student.sno = score.sno) ON course.cno = score.cno) ON score_1.sno = student.sno) ON course_1.cno = score_1.cno
WHERE (((student.sno)>"TZ03070020") AND ((score.score)>80) AND ((course.cname)="哲学") AND ((course_1.cname)="经济学基础") AND ((score_1.score)>80));