资金审批视图

SELECT dbo.canshu.id AS Expr1, t_UserLogin_1.ID AS Expr2, dbo.Shenp.ID,
      dbo.Shenp.请求时间, t_UserLogin_1.公司名称, t_UserLogin_1.公司全称,
      dbo.Shenp.收款公司, t_UserLogin_1.用户名, t_UserLogin_1.姓名,
      t_UserLogin_1.短信开启, t_UserLogin_1.联系电话, t_UserLogin_1.手机号码,
      dbo.Shenp.编号, dbo.Shenp.审批单号, dbo.Shenp.审批金额, dbo.Shenp.审批内容,
      dbo.Shenp.单据状态, dbo.Shenp.状态说明,
          (select 批复日期 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 批复日期,
          (select 审批意见nm from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 审批意见nm,
          (select 审批意见 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 审批意见,
          (select 批复金额 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 批复金额,
          (select 姓名 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) )) AS 审批人,
          (CASE WHEN(select 审批意见 from v_shenpjg where jgid= (SELECT max(jgid) FROM v_shenpjg WHERE (批复单号 = 审批单号) ))='同意' then dbo.Shenp.加密认证 ELSE '' END)AS 加密信息,

 t_UserLogin_1.等级,
      dbo.canshu.参数值 AS 审批状态, t_UserLogin_1.授信额度, dbo.Shenp.收款人,
      dbo.Shenp.帐号, dbo.Shenp.开户银行, dbo.Shenp.付出银行,
      dbo.Shenp.付出银行账号, dbo.Shenp.结算方式, dbo.Shenp.userid,
      (CASE WHEN
          (SELECT TOP 1 审批意见
         FROM v_shenpjg
         WHERE (批复单号 = 审批单号)
         ORDER BY 批复日期 DESC) = '同意' THEN dbo.Shenp.加密认证 ELSE '' END)
      AS 加密信息
FROM dbo.Shenp INNER JOIN
      dbo.t_UserLogin t_UserLogin_1 ON
      dbo.Shenp.userid = t_UserLogin_1.ID LEFT OUTER JOIN
      dbo.canshu ON dbo.Shenp.审批状态 = dbo.canshu.id