ID_, EVENT_ID_, COMPENSATION_ID_, PROPERTY_TYPE_ID_, PROPERTY_SUBJECT_ID_, PROPERTY_SUBJECT_NAME_, UNIT_, MODLE_, PRICE_, NUM_, TOTLE_, MEMO_, TRAFFIC_TEAM_, CREATE_BY_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT d.* FROM biz_compensation_info i JOIN biz_compensation_details d ON i.ID_=d.COMPENSATION_ID_ WHERE i.IS_DELE_ = '0' AND d.IS_DELE_='0' AND i.EVENT_ID_ = #{id}