if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[XT_VD_ProjectNameLX]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[XT_VD_ProjectNameLX]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE VIEW dbo.XT_VD_ProjectNameLX
AS
SELECT dbo.XT_VD_ProjectName.項目編碼, dbo.XT_VD_ProjectName.計劃編碼, 
      dbo.XT_VD_ProjectName.合并編碼, dbo.XT_VD_ProjectName.項目名稱, 
      dbo.XT_VD_ProjectName.用戶姓名, dbo.XT_VD_ProjectName.申報時間, 
      dbo.XT_VD_ProjectName.年度批次, dbo.XT_VD_ProjectName.項目類別名稱, 
      dbo.XT_VD_ProjectName.主持單位, dbo.XT_VD_ProjectName.所在區, 
      dbo.XT_VD_ProjectName.法人代碼, dbo.XT_VD_ProjectName.通訊地址, 
      dbo.XT_VD_ProjectName.郵編, dbo.XT_VD_ProjectName.聯系人, 
      dbo.XT_VD_ProjectName.聯系電話, dbo.XT_VD_ProjectName.電子郵件, 
      dbo.XT_VD_ProjectName.傳真, dbo.XT_VD_ProjectName.類別名稱, 
      dbo.XT_VD_ProjectName.責任人, dbo.XT_VD_ProjectName.責任處室, 
      dbo.XT_VD_ProjectName.項目進度, dbo.XT_VD_ProjectName.進度狀況, 
      dbo.XT_VD_ProjectName.處理意見, dbo.XT_VD_ProjectName.修改標志, 
      dbo.XT_VD_ProjectName.在線評審, dbo.XT_VD_ProjectName.推薦標志, 
      dbo.XT_VD_ProjectName.合同編碼, dbo.XT_VD_ProjectName.可行性報告, 
      dbo.XT_VD_ProjectName.注冊類型, dbo.XT_VD_ProjectName.企業特性, 
      dbo.XT_VD_ProjectName.項目類別, dbo.XT_VD_ProjectName.項目進度編碼, 
      dbo.XT_VD_ProjectName.進度狀態編碼, dbo.XT_VD_ProjectName.單位類型, 
      dbo.XT_VD_ProjectName.主管部門推薦結果, 
      dbo.XT_VD_ProjectName.主管部門推薦意見, dbo.XT_VD_ProjectName.推薦時間, 
      dbo.XT_VD_ProjectName.推薦部門, dbo.XT_VD_ProjectName.分配接收處室, 
      dbo.XT_VD_ProjectName.項目負責人, dbo.XT_VD_ProjectName.負責人姓名, 
      dbo.XT_VD_ProjectName.技術領域, dbo.XT_VD_ProjectName.項目類別編碼, 
      dbo.XT_VD_ProjectName.退回標志, dbo.XT_VD_ProjectName.退回進度, 
      dbo.XT_VD_ProjectName.目標進度, dbo.XT_VD_ProjectName.退回時間, 
      dbo.XT_VD_ProjectName.退回意見, dbo.XT_VD_ProjectName.責任專家, 
      dbo.XT_VD_ProjectName.確認分配, dbo.xt_td_ProjectLX.項目名稱 AS 項目名稱LX, 
      dbo.xt_td_ProjectLX.主持單位 AS 主持單位LX, 
      dbo.xt_td_ProjectLX.項目類別 AS 項目類別LX, 
      dbo.xt_td_ProjectLX.主要內容 AS 主要內容LX, 
      dbo.xt_td_ProjectLX.預期成果 AS 預期成果LX, 
      dbo.xt_td_ProjectLX.無償 AS 無償LX, dbo.xt_td_ProjectLX.貼息 AS 貼息LX, 
      dbo.xt_td_ProjectLX.有償 AS 有償LX, dbo.xt_td_ProjectLX.備注 AS 備注LX, 
      dbo.XT_TC_Depart.部門名稱
FROM dbo.XT_VD_ProjectName LEFT OUTER JOIN
      dbo.XT_TC_Depart ON 
      dbo.XT_VD_ProjectName.分配接收處室 = dbo.XT_TC_Depart.部門編碼 LEFT OUTER JOIN
      dbo.xt_td_ProjectLX ON 
      dbo.XT_VD_ProjectName.項目編碼 = dbo.xt_td_ProjectLX.項目編碼
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO