ID_, BIDDING_NOTICE_ID_, NOTICE_ID_, NOTICE_TITLE_, NOTICE_DETAILED_ID_, MAT_ID_, MAT_PLATCODE_, MAT_CATEGORY_CODE_, MAT_CODE_, MAT_NAME_, MAT_MATERIAL_, MAT_SPEC_, MAT_NUM_, MAT_UNIT_, PROCUREMENT_METHOD_, APPLICATION_METHOD_, DEMAND_DATE, HAS_QUALIFICATION_, PLANNED_PRICE_, MAT_BRAND_, MAT_BASE_EXT_, MAT_OTHER_EXT_, IS_TAX_, TAX_RATE_, EXE_STATUS_, EXE_TIME_, REMARKS_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_DEPT_ID_, WIN_BID_PRICE_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ select * from biz_win_bidding_notice_detaile ${ew.customSqlSegment} SELECT a.*,b.PROCURE_ORG_ID_,b.PROCURE_ORG_CODE_,b.PROCURE_ORG_NAME_, b.VENDOR_ID_,b.VENDOR_CODE_,b.VENDOR_NAME_,b.NOTICE_TYPE_,b.IS_AGENCY_PROCURE_ FROM biz_win_bidding_notice_detaile a LEFT JOIN biz_win_bidding_notice b ON a.WIN_NOTICE_ID_ = b.ID_ ${ew.customSqlSegment}