多表联合查询和子查询

最新推荐文章于 2023-06-09 11:26:33 发布

猪猪恶霸

最新推荐文章于 2023-06-09 11:26:33 发布

阅读量122

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/lqqcnsd/article/details/115731321

版权

sql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

select

corp_name,uni_sc_id,establish_date,reg_capital,
concat(datediff(year, trd_start_date,trd_end_date),'年') as validBusinessDate ,
reg_organ,industry_code,person_name,
person_cert_code,address,business_address,area_exercise,
d1.label as corpType,
d2.label as corpStatus,
d3.label as personCertType,
c.category_alias as industryCode

from corp_info as i

LEFT JOIN t_category c
on c.code = SUBSTRING (i.industry_code, 2 , 4 )
left join (SELECT * from sys_dict_detail WHERE dict_id = '1349225348796182530') as d1
on i.corp_type = d1.value
left join (SELECT * from sys_dict_detail WHERE dict_id = '1349172937746477058') as d2
on i.corp_status = d2.value
left join (SELECT * from sys_dict_detail WHERE dict_id = '1349191148009353218') as d3
on i.person_cert_type = d3.value

where uni_sc_id = #{uniScId}