ID_, ORDER_CODE_, CONTRACT_ID, CONTRACT_NUMBER_, STATUS_,CONTRACT_NAME_, MAT_COMPANY_ID_, MAT_COMPANY_CODE_, MAT_COMPANY_NAME_, VENDOR_ID_, VENDOR_NAME_, VENDOR_CODE_, ORDER_AMOUNT_, TAX_INVALUE_, ORDER_CREATEDATE_, ORDER_LASTCHGDATE_, 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_purchase_order ${ew.customSqlSegment} SELECT MAT_COMPANY_ID_,MAT_COMPANY_CODE_,MAT_COMPANY_NAME_ FROM biz_purchase_order ${ew.customSqlSegment} GROUP BY MAT_COMPANY_ID_