a.id AS "id", a.subject_code AS "subjectCode", a.subject_name AS "subjectName", a.yonyou_dept_code AS "yonyouDeptCode", a.yonyou_dept_name AS "yonyouDeptName", a.type_id AS "typeId", a.type_name AS "typeName", a.district_id AS "districtId", a.district_name AS "districtName", a.business_refund AS "businessRefund", a.create_by AS "createBy.id", a.sys_office_code AS "sysOfficeCode", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag" SELECT FROM sa_finance_subject_mapping a WHERE a.id = #{id}