ID_, PLAN_NO_, PLAN_TYPE_, WORKCLASS_, INSPECT_TYPE_, ROAD_ID_, ROAD_NAME_, ROAD_CODE_, START_PATROL_ID_, START_PATROL_NAME_, END_PATROL_ID_, END_PATROL_NAME_, TEAM_ID_, TEAM_FULL_ID_, FREQUENCY_, PLAN_START_DATE_, PLAN_END_DATE_, 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_ WITH team AS ( select id_,name_ from biz_base_team where is_dele_='0' ) select bip.* ,t.name_ as teamName from biz_inspection_plan bip left join team t on bip.team_id_= t.id_ ${ew.customSqlSegment}