ID_, TEAM_ID_, TEAM_FULL_ID_, USER_ID_, NAME_, ACCOUNT_, CODE_, TEL_, IS_OUT_, OUT_COMPANY_, TYPE_, POST_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_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 tm.*, r.name_ AS roadName, oc.name_ AS outCompanyName FROM biz_base_team_member tm LEFT JOIN biz_base_road r ON tm.road_id_ = r.id_ AND r.is_dele_ = '0' LEFT JOIN biz_base_out_company oc ON tm.OUT_COMPANY_ID_ = oc.id_ AND oc.is_dele_='0' ${ew.customSqlSegment} SELECT tm.*, r.name_ AS roadName, oc.name_ AS outCompanyName FROM biz_base_team_member tm LEFT JOIN biz_base_road r ON tm.road_id_ = r.id_ AND r.is_dele_ = '0' LEFT JOIN biz_base_out_company oc ON tm.OUT_COMPANY_ID_ = oc.id_ AND oc.is_dele_='0' WHERE tm.is_dele_='0' AND tm.id_=#{id} SELECT tm.*, oc.name_ AS outCompanyName FROM biz_base_team_member tm JOIN biz_bind_member bm ON tm.ID_=bm.MEMBER_ID_ LEFT JOIN biz_base_out_company oc ON tm.OUT_COMPANY_ID_ = oc.id_ AND oc.is_dele_='0' ${ew.customSqlSegment} SELECT tm.* FROM biz_base_team_member tm JOIN biz_bind_member bm ON tm.ID_=bm.MEMBER_ID_ tm.is_dele_='0' AND bm.team_id_=#{teamId}