id_, report_id_, enterprise_id_, enterprise_code_ SELECT ra.*, info.name_ as name, info.name_en_ as nameEn FROM qf_report_range ra INNER JOIN qf_enterprise_info info on ra.enterprise_id_ = info.id_ WHERE ra.report_id_ = #{reportId} SELECT si.* FROM qf_enterprise_info si LEFT JOIN qf_report_range rs ON rs.enterprise_code_ = si.code_ WHERE rs.report_id_ = #{reportId}