pg多练表表公式

公式

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