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
多表关联视图
最新推荐文章于 2021-05-09 10:08:56 发布