SELECT Xs.学号, Xs.姓名, Xs.性别, Xs.学院, Kc.课程名称, Cj.成绩;
 FROM  stud!xs INNER JOIN stud!cj;
    INNER JOIN stud!kc ;
   ON  Cj.课程编号 = Kc.课程编号 ;
   ON  Xs.学号 = Cj.学号;
 ORDER BY Xs.学院 DESC, Xs.学号;
 INTO TABLE new.dbf
