sql视图怎么建

create view 用户名.视图名
(各字段在视图中的别名，如果这个地方不写，一般默认为你查询sql中的名字)
as
select
bas_job.job_name , bas_resume.member_name,
bas_resume.work_year,bas_resume.high_xl,bas_resume.money_require,
bas_resume.spe_name,bas_resume.pub_date
from
dbo.bas_job , dbo.bas_resume ,dbo.bas_resume_manage
where bas_job.job_id=bas_resume_manage.job_id and
bas_resume.member_id=bas_resume_manage.member_id

create view 视图名 as
select
bas_job.job_name , bas_resume.member_name,
bas_resume.work_year,bas_resume.high_xl,bas_resume.money_require,
bas_resume.spe_name,bas_resume.pub_date

from
dbo.bas_job , dbo.bas_resume ,dbo.bas_resume_manage

where bas_job.job_id=bas_resume_manage.job_id and
bas_resume.member_id=bas_resume_manage.member_id