7-16.txt

来自「超市进销存管理系统 学生学籍管理系统 1、把源代码解压到适当的目录下（教材讲」· 文本 代码 · 共 19 行

【例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
所得到的结果完全相同。