a.ID_ AS "bizProjectManageQualityChange.id", a.VALID_FLAG_ AS "bizProjectManageQualityChange.validFlag", a.UPDATE_TIME_ AS "bizProjectManageQualityChange.updateTime", a.UPDATE_ORG_NAME_ AS "bizProjectManageQualityChange.updateOrgName", a.UPDATE_ORG_ID_ AS "bizProjectManageQualityChange.updateOrgId", a.UPDATE_NAME_ AS "bizProjectManageQualityChange.updateName", a.UPDATE_COMPANY_NAME_ AS "bizProjectManageQualityChange.updateCompanyName", a.UPDATE_COMPANY_ID_ AS "bizProjectManageQualityChange.updateCompanyId", a.UPDATE_BY_ AS "bizProjectManageQualityChange.updateBy", a.TEST_ID_ AS "bizProjectManageQualityChange.testId", a.TENANT_ID_ AS "bizProjectManageQualityChange.tenantId", a.REMARKS_ AS "bizProjectManageQualityChange.remarks", a.REFORM_USE_ID_, a.REFORM_SEQ_, a.REFORM_ID_, a.REFORM_FLAG_ AS "bizProjectManageQualityChange.reformFlag", a.REFORM_DESCRIPTION_, a.REFORM_DEPART_, a.REFORM_DATE_, a.LAST_TIME_ AS "bizProjectManageQualityChange.lastTime", a.IS_DELE_, a.CREATE_TIME_ AS "bizProjectManageQualityChange.createTime", a.CREATE_ORG_NAME_ AS "bizProjectManageQualityChange.createOrgName", a.CREATE_ORG_ID_ AS "bizProjectManageQualityChange.createOrgId", a.CREATE_NAME_ AS "bizProjectManageQualityChange.createName", a.CREATE_COMPANY_NAME_ AS "bizProjectManageQualityChange.createCompanyName", a.CREATE_COMPANY_ID_ AS "bizProjectManageQualityChange.createCompanyId", a.CREATE_BY_ AS "bizProjectManageQualityChange.createBy", a.CONFIRM_USER_ID_, a.CONFIRM_RESULT_ AS "bizProjectManageQualityChange.confirmResult", a.CONFIRM_DESCRIPTION_ AS "bizProjectManageQualityChange.confirmDescription", a.CONFIRM_DATE_, a.COMPANY_NAME_ AS "bizProjectManageQualityChange.companyName", a.COMPANY_ID_ AS "bizProjectManageQualityChange.companyId", b.VERSION_, b.VALID_FLAG_ AS "bizProjectManageQuality.validFlag", b.UPDATE_TIME_ AS "bizProjectManageQuality.updateTime", b.UPDATE_ORG_NAME_ AS "bizProjectManageQuality.updateOrgName", b.UPDATE_ORG_ID_ AS "bizProjectManageQuality.updateOrgId", b.UPDATE_NAME_ AS "bizProjectManageQuality.updateTime", b.UPDATE_COMPANY_NAME_ AS "bizProjectManageQuality.updateCompanyName", b.UPDATE_COMPANY_ID_ AS "bizProjectManageQuality.updateCompanyId", b.UPDATE_BY_ AS "bizProjectManageQuality.updateBy", b.TEST_USER_ID_ AS "bizProjectManageQuality.testUserId", b.TEST_USER_NAME_ AS "bizProjectManageQuality.testUserName", b.TEST_TIME_ AS "bizProjectManageQuality.testTime", b.TEST_RESULT_ AS "bizProjectManageQuality.testResult", b.TEST_LOCATION_ AS "bizProjectManageQuality.location", b.TEST_ID_ AS "bizProjectManageQuality.testId", b.TENANT_ID_ AS "bizProjectManageQuality.tenantId", b.REMARKS_ AS "bizProjectManageQuality.remarks", b.REFORM_FLAG_ AS "bizProjectManageQuality.reformFlag", b.REFORM_COUNT_ AS "bizProjectManageQuality.reformCount", b.LAST_TIME_ AS "bizProjectManageQuality.lastTime", b.IS_DELE_ AS AS "bizProjectManageQuality.isDele", b.ID_ AS "bizProjectManageQuality.id", b.CREATE_TIME_ AS "bizProjectManageQuality.createTime", b.CREATE_ORG_NAME_ AS "bizProjectManageQuality.createOrgName", b.CREATE_ORG_ID_ AS "bizProjectManageQuality.createOrgId", b.CREATE_NAME_ AS "bizProjectManageQuality.createName", b.CREATE_COMPANY_NAME_ AS "bizProjectManageQuality.createCompanyName", b.CREATE_COMPANY_ID_ AS "bizProjectManageQuality.createCompanyId", b.CREATE_BY_ AS "bizProjectManageQuality.createBy", b.CONFIRM_RESULT_ AS "bizProjectManageQuality.confirmResult", b.COMPANY_NAME_ AS "bizProjectManageQuality.companyName", b.COMPANY_ID_ AS "bizProjectManageQuality.companyId" SELECT * FROM ( SELECT a.*,b.REFORM_COUNT_,b.TEST_TIME_,b.TEST_LOCATION_,b.TEST_USER_NAME_,b.TEST_USER_ID_,b.TEST_RESULT_ FROM biz_project_manage_quality_change a LEFT JOIN biz_project_manage_quality b ON a.TEST_ID_ = b.TEST_ID_ )T1 ${ew.customSqlSegment} SELECT * FROM biz_project_manage_quality_change ${ew.customSqlSegment}