select v1.lookup_value_name as 列名1, v.lookup_value_name as 列名2
from 主表名 i
left join (lookup_type t left join lookup_value v on t.lookup_type_id = v.lookup_type_id )
on i.要置换的列名1=v.lookup_value_code
left join (lookup_type t1 left join lookup_value v1 on t1.lookup_type_id = v1.lookup_type_id )
on i.要置换的列名2=v1.lookup_value_code
where t.lookup_type_id =‘列1类型id ’ and t1.lookup_type_id =‘列2类型id ’
说明:1、lookup_type /lookup_value 分别为“值列类型表”和“值对应值表”
2、如再有更多列要置换只需在后添加
left join (lookup_type t left join lookup_value v on t.lookup_type_id = v.lookup_type_id )
on i.要置换的列名1=v.lookup_value_code
同事将值类型条件加在where条件之后