视图

use xland
go
create view my_vw
as
   select a.id, a.title,u.username from mytable a join  [user] u on u.id = a.uid

use xland
go
select * from my_vw

select a.id, a.title,u.username from mytable a join  [user] u on u.id = a.uid