ID_, HANDLE_NOTICE_ID_, PROJECT_NUMBER_, HANDLE_NOTICE_TITLE_, PROCURE_ORG_ID_, PROCURE_ORG_CODE_, PROCURE_ORG_NAME_, BIDDING_COMPANY_NAME_, BIDDING_COMPANY_ID_, BIDDING_USER_ID_, BIDDING_USER_PHONE_, BIDDING_USER_NAME_, NOTICE_TITLE_, ESTABLISHMENT_NAME_, SEND_TIME_, CONFIRM_TIME_, TYPE_, STATUS_, REMARKS_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_NAME_, UPDATE_DEPT_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ select * from biz_win_bidding_notice ${ew.customSqlSegment} SELECT DISTINCT a.VENDOR_ID_,a.VENDOR_CODE_,a.VENDOR_NAME_ FROM biz_win_bidding_notice a LEFT JOIN biz_win_bidding_notice_detaile b ON a.ID_ = b.WIN_NOTICE_ID_ ${ew.customSqlSegment}