添加视图

CREATE VIEW [dbo].[PerJob]
AS
SELECT zp.id, zp.uid, per.MainMenu, per.subMenu, per.ComName, per.ComType, zp.Idate,
      zp.JobKind, zp.JobName, zp.WorkYear, zp.Knowledge, zp.JobRequire,
      per.Introduction, zp.MainMenu AS zpMainMenu, zp.subMenu AS zpsubMenu,
      zp.ManNum, zp.Auto, per.id AS perid, zp.JobState, per.Flag
FROM dbo.Job_ZhaoPing zp INNER JOIN
      dbo.Job_Person per ON zp.uid = per.id