SELECT

t.dict_code,

m.*,

  t.label itemName,

t.VALUE itemValue

FROM

t_base_dict_val t

LEFT JOIN (

SELECT

d.content,

d.type,

minfo.years,

minfo.dept_id,

d.is_del

FROM

eval_dept_info d

JOIN eval_dept_main_info minfo ON d.main_info_id = minfo.id

) m ON m.type = t.`value`

AND m.dept_id = 8

AND m.years = 2019

WHERE

t.dict_code = 'evaluateType'

AND (m.is_del = 0 OR m.is_del IS NULL)

/////////////只能 left join 一次///////////////