求大神来看看。mysql可以正常执行。但是查询不到数据
云墨浅殇 2015-08-25 05:33:13 begin
SELECT o.id,o.kpi_contentid,o.kpi_content_score,o.kpi_man,o.kpi_time,o.approve_man,o.appore_type,k.kpi_content,e1.employee_name kpi_name,
e1.employee_url kpi_url,e2.employee_name approve_name,e2.employee_url approve_url
from tb_xa_userourkpi o inner JOIN tb_xa_userkpicontent k
on o.kpi_contentid=k.id inner JOIN tb_xa_comemployee e1
on o.kpi_man=e1.employee_count inner JOIN tb_xa_comemployee e2
on o.approve_man=e2.employee_count where o.kpi_man=e1.employee_count
and o.kpi_time=(SELECT max(oo.kpi_time) FROM tb_xa_userourkpi oo
where oo.kpi_man=employeeno)
or o.id in (SELECT range_recordid from(SELECT range_recordid FROM tb_xa_userrangelog l where l.from_type=23 and
((l.range_type=1 and l.to_objectid=(select e.id from tb_xa_comemployee e where e.status=1 and e.employee_count=employeeno)) or
(l.range_type=2 and l.to_objectid=(SELECT e.departmentid from tb_xa_comemployee e where e.employee_count=employeeno)) or
(l.range_type=3 and l.to_objectid=(SELECT e.branchid from tb_xa_comemployee e where e.employee_count=employeeno)))) as temp) ORDER BY kpi_time ;
end