摘要:
结果如下: 阅读全文
摘要:
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; 阅读全文