第1个回答 2016-06-14
create view dbo.view1(sno,sname,cname,grade)with schemabindingas select Student.Sno,Student.Sname,Course.Cname,StudentCourse.Gradefrom dbo.Student join dbo.StudentCourse on StudentCourse.Sno=Student.Snojoin dbo.Course on Course.Cno=StudentCourse.Cno本回答被提问者采纳