多表关联视图

SELECT     a.id, CONVERT(VARCHAR(10),a.endate, 120) AS endate1, a.corp_id, a.dept_id, a.position_id, a.user_id,

                      a.login_name, a.op_id, a.op_corp_id, a.last_aprv_user, a.last_aprv_time, CONVERT(VARCHAR(16),
                      a.last_update_time, 120) AS last_update_time1,a.last_update_time, a.approval_step, a.remark, b.short_name, c.department_name, d.position_name,
                      CASE l.sex WHEN 1 THEN '男' ELSE '女' END AS sex1, CASE l.age is null THEN '不限' ELSE cast(l.age as varchar(50)) END AS age1,
                      CASE a.bill_state WHEN 100 THEN '审批结束' WHEN 255 THEN '作废' ELSE g.state_name END AS bill_state1,l.user_name AS last_aprv_name
FROM         dbo.hr_entry AS a LEFT OUTER JOIN
                      dbo.b_corporation AS b ON a.corp_id = b.corporation_id LEFT OUTER JOIN
                      dbo.b_department AS c ON a.dept_id = c.department_id LEFT OUTER JOIN
                      dbo.b_position AS d ON a.position_id = d.position_id LEFT OUTER JOIN
                      dbo.bsc_approvalflow_state AS g ON a.bill_state = g.state_id AND a.bill_type = g.bill_type LEFT OUTER JOIN
                      dbo.sys_user AS l ON a.last_aprv_user = l.user_id