当数据库信息表中有很多字段是以字典表编号的形式存储,可以考虑用这个方法,比如:
select a.asset_id,c.context_info as asset_type,d.context_info as asset_name,asset_brand,e.context_info as department_id,buy_price,f.context_info as asset_status,g.context_info as
当数据库信息表中有很多字段是以字典表编号的形式存储,可以考虑用这个方法,比如:
select a.asset_id,c.context_info as asset_type,d.context_info as asset_name,asset_brand,e.context_info as department_id,buy_price,f.context_info as asset_status,g.context_info as