ID_, NOTICE_ID_, PURCHASING_APPLICATION_DETAIL_ID_, PURCHASING_APPLICATION_ID_, NOTICE_TITLE_, NOTICE_NUMBER_, QUOTATION_ROUNDS_, MAT_ID_, MAT_COMPANY_ID_, MAT_COMPANY_CODE_, MAT_COMPANY_NAME_, MAT_PLATCODE_, MAT_CATEGORY_CODE_, MAT_CODE_, MAT_NAME_, MAT_MATERIAL_, MAT_SPEC_, MAT_NUM_, MAT_UNIT_, DEMAND_DATE, MAT_BRAND_, MAT_BASE_EXT_, MAT_OTHER_EXT_, TAX_RATE_, BID_STATUS_, UNLOAD_ADDRESS_, 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_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_ select * from biz_mat_approval_details ${ew.customSqlSegment} select * from biz_mat_approval_details ${ew.customSqlSegment} select * from biz_mat_approval_details ${ew.customSqlSegment} select detail.*,IF(ISNULL(eva.ID_),0,1) as 'isEva' from biz_mat_approval_details detail LEFT JOIN (SELECT * FROM biz_bid_evaluation WHERE IS_DELE_ = '0') eva ON detail.ID_ = eva.NOTICE_DETAILED_ID_ AND detail.NOTICE_ID_ = eva.NOTICE_ID_ ${ew.customSqlSegment} SELECT detail.*,quo.QUOTATION_COMPANY_ID_,quo.QUOTATION_COMPANY_CODE_,quo.QUOTATION_COMPANY_NAME_,quo.QUOTATION_PRICE_ as 'myPrice' FROM biz_bidding_quotation quo LEFT JOIN biz_mat_approval_details detail ON quo.NOTICE_DETAILED_ID_ = detail.ID_ AND quo.NOTICE_ID_ = detail.NOTICE_ID_ ${ew.customSqlSegment}