SQL查询请假时间明细表

查询请假类型所有在职的人员的请假明细（包含请假天数，请假时长）

select  hr.lastname 姓名,qjksrq 开始日期,qjkssj 开始时间,qjjsrq 结束日期,qjjssj 结束时
间,datediff(day,qjksrq,qjjsrq ) as 天数,datediff(minute,qjkssj,qjjssj)  as 时长,
(case qjlx  when 1 then '事假' when 2 then '病假' when 5 then '探亲假' when -6 then '年假' 
when 7 then '婚假' when 8 then '产假' when 9 then '哺乳假' when 10 then '丧假'else '调休' 
end)类型
from formtable_main_3 fm
left join HrmDepartment bm on bm.id=fm.sqbm
left join HrmResource hr on hr.id=fm.sqr
where qjksrq>'2018-07-01' and hr.status=1 and hr.subcompanyid1='5'   order by  hr.lastname