select t.*,fun_tr_user('1','id_name') user_name,d.dept_name
from TBL_OA_PERFORMANCE_HIS_EXAM t
left join tbl_base_dept d
on d.dept_id in
(select min(ud.dept_id) from TBL_BASE_USER_DEPT ud where ud.user_id='1')
where t.time_year=2017 and t.pro_id=0 and t.examined='1'
解决办法:将条件写在where 后面
select t.*, fun_tr_user('1', 'id_name') user_name, d.dept_name
from TBL_OA_PERFORMANCE_HIS_EXAM t, tbl_base_dept d
where t.time_year = 2017
and t.pro_id = 0
and t.examined = '1'
and d.dept_id in (select min(ud.dept_id)
from TBL_BASE_USER_DEPT ud
where ud.user_id = '1')