7-16.txt

超市进销存管理系统 学生学籍管理系统 1、把源代码解压到适当的目录下（教材讲到的目录）。 2、1-9章 打开对应章节例子代码复制到命令窗口

【例7.16】输出所有学生的成绩单，要求给出学号、姓名、课程号、课程名和成绩。
SELECT xsqk.no AS "学号",xsqk.name AS "姓名",;
xscj.courseid AS "课程号",xscj.score AS "成绩",;
kc.course AS "课程名";
FROM xsqk.dbf,xscj.dbf,kc.dbf;
WHERE xsqk.no=xscj.no AND xscj.courseid=kc.courseid;
ORDER BY xscj.score DESC

如果采用内部连接方式，则命令
SELECT xsqk.no AS "学号",xsqk.name AS "姓名",;
xscj.courseid AS "课程号",xscj.score AS "成绩",;
kc.course AS "课程名";
FROM xsqk INNER JOIN xscj;
INNER JOIN kc;
ON xscj.courseid=kc.courseid;
ON xsqk.no=xscj.no;
ORDER BY xscj.score DESC
所得到的结果完全相同。