SELECT PATIENT_ID_VALUE,SCHEDULED_START_DATE,OPEG_FILE_PATH,OPEG_FILE_NAME FROM M_PATIENT_ID natural join( SELECT * from T_CP_EXAM natural join T_EXAM where OPEG_FILE_NAME='OP_test128_Normal.opeg')