mapper.xml
select * from (
SELECT a.*,
b.`id` AS audit_id,
IFNULL(b.`status`,0) AS audit_status,
b.`reason` AS audit_reason,
b.`create_time` AS audit_create_time,
b.`create_by` AS audit_create_by,
b.`audit_time`,
b.`audit_by`,
b.`dept_id`,
b.`company_id`,
IFNULL(d.short_name, d.dept_name) AS company_name
FROM `xxx` a
LEFT OUTER JOIN `xxx` b ON a.`id` = b.`tbl_key` and b.`tbl_name` = 'hse_prevent_hazard_affirm'
LEFT OUTER JOIN `xxx` d ON d.dept_id = b.`company_id`
) t
${ew.customSqlSegment}
mapper.java
IPage<HsePreventHazardAffirm> getList(IPage<HsePreventHazardAffirm> page
, @Param(Constants.WRAPPER) Wrapper<HsePreventHazardAffirm> wrapper);