create view st_view.sql

在学习SQL Server过程中整理的T-SQL语句

use test
go
create view st_view
as
select XS.sno,XS.sname,KC.cname,XS_KC.score
       from XS,KC,XS_KC
       where XS.sno=XS_KC.sno and KC.cno=XS_KC.cno
go