c# 第十一章上机练习3

最新推荐文章于 2020-03-15 22:41:32 发布

_苏小白

最新推荐文章于 2020-03-15 22:41:32 发布

阅读量805

点赞数

本文链接：https://blog.csdn.net/qq_36074043/article/details/53334843

版权

	--上机练习3
	
	SELECT StudentName, GradeName, Phone FROM dbo.Student S,dbo.Grade G WHERE S. GradeId=G. GradeId
	 
	 SELECT GradeName,SubjectName, ClassHour FROM dbo.Subject J,dbo.Grade G WHERE J.GradeId=G. GradeId AND G.GradeId=1
	 
	 SELECT  StudentName,StudentResult, ExamDate FROM dbo.Student S,dbo.Result R WHERE S.StudentNo=R.StudentNo AND SubjectId=1
	 
	  SELECT  SubjectName,StudentResult, ExamDate FROM dbo.Subject j,dbo.Result R WHERE j.SubjectId=R.SubjectId AND StudentNo='s1101007'

SELECT S.StudentNo,SubjectName,StudentResult,ExamDate  FROM dbo.Student S,dbo.Result R,dbo.Subject J WHERE S.StudentNo=R.StudentNo AND S.GradeId=J.GradeId