ID_, ORG_ID_, COMPANY_CODE_, COMPANY_NAME_, COMPANY_ORGCODE_, COMPANY_EBE_, COMPANY_REGDATE_, COMPANY_REGDATE_END_, PROVINCE_, CITY_, COUNTY_, COMPANY_ADDR_, COMPANY_CONTACT_, CONTACT_TEL_, OWNER_TYPE_, REGISTERED_CAPITAL_, REGISTERED_CAPITAL_TYPE_, MAIL_, POST_CODE_, CREDIT_CODE_, INTERBANK_, BANK_, OPENING_BANK_, MAILING_ADDRESS_, TAXPAYER_TYPE_, HISTORY_COMPANY_CODE_, REGIS_TYPE_, INDUSTRY_CODE_, INDUSTRY_NAME_, 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_ID_, UPDATE_DEPT_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, VERSION_, TENANT_ID_, IS_TEMP_ENTERPRISE_ select * from biz_enterprise ${ew.customSqlSegment} SELECT a.*,b.COMPANY_ORGCODE_ as 'companyOrgcode' FROM uc_org a LEFT JOIN (SELECT * FROM biz_enterprise WHERE IS_DELE_ = '0') b ON a.code_ = b.COMPANY_CODE_ ${ew.customSqlSegment}