SQL server入门[第五章] 事务，索引和视图
me,学号 = stuinfo.stuno,笔试成绩 = writtenexam,机试成绩 = labexam,平均
分 = (writtenexam+labexam)/2
from stuinfo left join stumarks on stuinfo.stuno = stumarks.stuno
go
select * from view_stuinfo_stumarks
author: k&j
QQ:403455281
15:59 2007-4-23