multi_view.sql

本程序中即有讲义

use pubs
go
create view view1 as
select * from jobs
go
select * from view1
go
create view view2 as
select * from employee

go
select * from  view2

go
create view view3 as 
select emp_id,a.job_id ,job_lvl,min_lvl,max_lvl from 
view1 as a inner join view2
on a.job_id=view2.job_id
go
select * from view3