SELECT Student2.*, Sc.成绩;
FROM sdb!student2 INNER JOIN sdb!sc;
INNER JOIN sdb!course2 ;
ON Sc.课程号 = Course2.课程号 ;
ON Student2.学号 = Sc.学号;
WHERE Course2.课程号 = "计算机软件基础";
AND Sc.成绩 <= 85;
ORDER BY Student2.学号;
INTO TABLE ..\..\wexam\00000000\noex.dbf 作者: maggie 时间: 2006-3-12 22:49