ID_, CHANGE_ID_, CHANGE_REASON_, CHANGE_APPLY_USER_, CHANGE_APPLY_UNIT_, CHANGE_APPLY_DATE_, CHANGE_APPLY_CONTENTS_, CHANGE_APPLY_REMARKS_, CHANGE_APPLY_EXPORT_FLAG_, CHANGE_APPLY_IMPORT_FLAG_, CHANGE_EXECUTE_USER_, CHANGE_EXECUTE_UNIT_, CHANGE_EXECUTE_DATE_, CHANGE_EXECUTE_ID_, CHANGE_EXECUTE_FLAG_, CHANGE_CONFIRM_USER_, CHANGE_CONFIRM_UNIT_, CHANGE_CONFIRM_STATUS_, CHANGE_CONFIRM_DATE_, VALID_FLAG_, COMPANY_ID_, COMPANY_NAME_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_ a.ID_ AS 'bizProjectContract.id', a.PROJECT_ID_ AS 'bizProjectContract.projectId', a.PROJECT_NAME_ AS 'bizProjectContract.', a.PROJECT_NAME_ AS 'bizProjectContract.projectName', a.CONTRACT_ID_ AS 'bizProjectContract.contractId', a.REMARKS_ AS 'bizProjectContract.remarks', a.ROAD_SEGMENT_ID_ AS 'bizProjectContract.roadSegmentId', a.OFFICE_ID_ AS 'bizProjectContract.officeId', a.CONTRACT_NAME_ AS 'bizProjectContract.contractName', a.FIRST_PARTY_ AS 'bizProjectContract.firstParty', a.SECOND_PARTY_ AS 'bizProjectContract.secondParty', a.THIRD_PARTY_ AS 'bizProjectContract.thirdParty', a.CONTRACT_NUMBER_ AS 'bizProjectContract.contractNumber', a.UNIQUE_NUMBER_ AS 'bizProjectContract.uniqueNumber', a.CLASSIFICATION_NUMBER_ AS 'bizProjectContract.classificationNumber', a.CONTRACT_INITIATOR_ AS 'bizProjectContract.contractInitiator', a.CONTRACT_AMOUNT_ AS 'bizProjectContract.contractAmount', a.RETENTION_MONEY_ AS 'bizProjectContract.retentionMoney', a.SETTLEMENT_AMOUNT_ AS 'bizProjectContract.settlementAmount', a.CONTRACT_DATE_ AS 'bizProjectContract.contractDate', a.CONTRACT_CONTENTS_ AS 'bizProjectContract.contractContents', a.CONFIRMATION_MODE_ AS 'bizProjectContract.confirmationMode', a.VALID_FLAG_ AS 'bizProjectContract.validFlag', a.COMPANY_ID_ AS 'bizProjectContract.companyId', a.COMPANY_NAME_ AS 'bizProjectContract.companyName', b.ID_ AS 'bizApplicationForChangeOfContract.id', b.CHANGE_ID_ AS 'bizApplicationForChangeOfContract.changeId', b.CHANGE_REASON_ AS 'bizApplicationForChangeOfContract.changeReason', b.CHANGE_APPLY_USER_ AS 'bizApplicationForChangeOfContract.changeApplyUser', b.CHANGE_APPLY_UNIT_ AS 'bizApplicationForChangeOfContract.changeApplyUnit', b.CHANGE_APPLY_DATE_ AS 'bizApplicationForChangeOfContract.changeApplyDate', b.CHANGE_APPLY_CONTENTS_ AS 'bizApplicationForChangeOfContract.changeApplyContents', b.CHANGE_APPLY_REMARKS_ AS 'bizApplicationForChangeOfContract.changeApplyRemarks', b.CHANGE_APPLY_EXPORT_FLAG_ AS 'bizApplicationForChangeOfContract.changeApplyExportFlag', b.CHANGE_APPLY_IMPORT_FLAG_ AS 'bizApplicationForChangeOfContract.changeApplyImportFlag', b.CHANGE_EXECUTE_USER_ AS 'bizApplicationForChangeOfContract.changeExecuteUser', b.CHANGE_EXECUTE_UNIT_ AS 'bizApplicationForChangeOfContract.changeExecuteUnit', b.CHANGE_EXECUTE_DATE_ AS 'bizApplicationForChangeOfContract.changeExecuteDate', b.CHANGE_EXECUTE_ID_ AS 'bizApplicationForChangeOfContract.changeExecuteId', b.CHANGE_EXECUTE_FLAG_ AS 'bizApplicationForChangeOfContract.changeExecuteFlag', b.CHANGE_CONFIRM_USER_ AS 'bizApplicationForChangeOfContract.changeConfirmUser', b.CHANGE_CONFIRM_UNIT_ AS 'bizApplicationForChangeOfContract.changeConfirmUnit', b.CHANGE_CONFIRM_STATUS_ AS 'bizApplicationForChangeOfContract.changeConfirmStatus', b.CHANGE_CONFIRM_DATE_ AS 'bizApplicationForChangeOfContract.changeConfirmDate', b.VALID_FLAG_ AS 'bizApplicationForChangeOfContract.validFlag', b.COMPANY_ID_ AS 'bizApplicationForChangeOfContract.companyId', b.COMPANY_NAME_ AS 'bizApplicationForChangeOfContract.companyName' SELECT * FROM biz_application_for_change_of_contract ${ew.customSqlSegment} SELECT FROM biz_project_contract a INNER JOIN biz_application_for_change_of_contract b ON a.ID_ = b.CONTRACT_ID_ ${ew.customSqlSegment}