create view st_view.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 8 行

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