10 2018 档案
摘要:结果如下:
阅读全文
摘要:SELECT r.Studentno AS '"李"同学学号',studentname AS '姓名',StudentResult AS '成绩' FROM result AS r INNER JOIN student AS s ON r.StudentNo=s.StudentNo AND stud
阅读全文
摘要:SELECT studentno AS '学号',studentname AS '姓名',gradename AS '年级' FROM student AS s LEFT JOIN grade AS g ON s.gradeid= g.gradeid;
阅读全文