SELECT studentno AS '学号',studentname AS '姓名',gradename AS '年级' FROM student AS s LEFT JOIN grade AS g ON s.gradeid= g.gradeid;
转载于:https://www.cnblogs.com/Suaron/p/9777463.html
SELECT studentno AS '学号',studentname AS '姓名',gradename AS '年级' FROM student AS s LEFT JOIN grade AS g ON s.gradeid= g.gradeid;
转载于:https://www.cnblogs.com/Suaron/p/9777463.html