ID_, Column_31, Column_30, SUPPLIER_TYPE_ID_, Column_45, Column_29, Column_28, Column_27, Column_26, Column_25, Column_24, Column_23, Column_44, Column_43, Column_42, Column_41, Column_40, Column_39, Column_37, Column_46, Column_38, Column_36, Column_35, Column_47, Column_34, Column_33, Column_57, SYS_AREAS_ID_, SYS_AREAS_NAME_, SYS_AREAS_ID_PATH_, SYS_AREAS_NAME_PATH_, Column_53, Column_52, Column_51, Column_50, Column_49, Column_48, Column_61, Column_60, Column_59, REMARKS_, SN_, 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_supplier_org ${ew.customSqlSegment} select * from biz_supplier_type a left join (select * from biz_supplier_org_supplier_type where SUPPLIER_ORG_ID_ = '${ew}')b on a.id_= b.SUPPLIER_TYPE_ID_ select * from biz_qualification_label a left join (select * from BIZ_SUPPLIER_ORG_QUALIFICATION_LABEL where SUPPLIER_ORG_ID_ = '${ew}')b on a.id_= b.QUALIFICATION_LABEL_ID_