公式
select
主表.字段 as 姓名,
从表1.名称 as 地区,
从表2.名称 as 民族
from 主表
LEFT JOIN 从表1 as table1 on 主表.字段 = tabl1.字段
LEFT JOIN 从表2 as table2 on 主表.字段 = tabl2.字段
SELECT
ef_col1 as 姓名,
col3.li_name as 地区,
col5.li_name as 民族
FROM
ef_temp_e64_10
LEFT JOIN t_dictionaries_item AS col3 ON ef_temp_e64_10.ef_col3 = col3.li_id
LEFT JOIN t_dictionaries_item AS col5 ON ef_temp_e64_10.ef_col5 = col5.li_id