十一章 上机5

来源:互联网 发布:怎么看淘宝店铺的销量 编辑:程序博客网 时间:2024/06/11 09:47
SELECT J.SubjectName AS 科目名称,R.StudentNo AS 学号,R.StudentResult AS 分数FROM Subject AS JLEFT OUTER JOIN Result AS R ON (R.SubjectId = J.SubjectId)-------------------------------------------------------------------------SELECT G.GradeName AS 年级,S.StudentNo AS 学号,S.StudentName AS 姓名FROM Grade AS GLEFT OUTER JOIN Student AS S ON (G.GradeId = S.GradeId)

0 0
原创粉丝点击