ID_, CAR_NUMBER_, NAME_, CAR_BRAND_, USE_TYPE_, CAR_CLASS_, BUY_DATE_, REGISTRATION_DATE_, EXPIRATION_DATE_, ADD_DATE_, IS_ALARM_, IS_FILING_, FRAME_NUMBER_, ENGINE_NUMBER_, FUEL_CONSUMPTION_, SEATS_NUMBER_, CAR_LOAD_, CAR_COLOUR_, SUITABILITY_CAR_, SUITABILITY_TRUCK_, IS_OWNED_, COMPANY_, TEAM_ID_, TEAM_FULL_ID_, ROAD_ID_, RESCUE_ID_, DRIVING_LICENSE_F_, DRIVING_LICENSE_B_, CAR_SIDE_URL_, CAR_FRONT_URL_, CAR_BEHIND_URL_, OPERATORS_, SIM_NUMBER_, ICCID_, IMSI_, APAN_, REMARKS_, 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 tc.*,c.CAR_NUMBER_,c.NAME_,c.CAR_BRAND_,c.USE_TYPE_,c.CAR_CLASS_ FROM biz_bind_car tc JOIN biz_base_car c ON tc.car_id_=c.id_ WHERE c.is_dele_='0' AND tc.is_dele_='0' AND tc.team_id_ = #{teamId}