摘要:
结果如下: 阅读全文
posted @ 2018-10-16 18:15
Sauron_Three
阅读(867)
评论(0)
推荐(0)
摘要:
SELECT r.Studentno AS '"李"同学学号',studentname AS '姓名',StudentResult AS '成绩' FROM result AS r INNER JOIN student AS s ON r.StudentNo=s.StudentNo AND stud 阅读全文
posted @ 2018-10-13 09:45
Sauron_Three
阅读(1801)
评论(0)
推荐(0)
摘要:
SELECT studentno AS '学号',studentname AS '姓名',gradename AS '年级' FROM student AS s LEFT JOIN grade AS g ON s.gradeid= g.gradeid; 阅读全文
posted @ 2018-10-12 12:16
Sauron_Three
阅读(1452)
评论(0)
推荐(0)
浙公网安备 33010602011771号