SELECT SUBSTR(MIN(TMP.ENTRYDD),0,4)||'/'||SUBSTR(MIN(TMP.ENTRYDD),3,2)||'/'||SUBSTR(MIN(TMP.ENTRYDD),5,2)||'~' ||SUBSTR(MAX(TMP.ENTRYDD),0,4)||'/'||SUBSTR(MAX(TMP.ENTRYDD),3,2)||'/'||SUBSTR(MAX(TMP.ENTRYDD),5,2) AS ENTRYDD , SUM(TMP.EDUCRCOGTM) AS EDUCRCOGTM , TMP.SPCVOLUNTRFILD AS SPCVOLUNTRFILD FROM ( SELECT ATTD.ENTRYDD AS ENTRYDD , ATTD.EDUCRCOGTM AS EDUCRCOGTM , VOTR.SPCVOLUNTRFILD AS SPCVOLUNTRFILD , ATTD.ATTDABSNFLAG AS ATTDABSNFLAG FROM AST.AAAHEDUCATTD ATTD LEFT OUTER JOIN AST.AAAHACTINFO INFO ON ( ATTD.INSTCD=INFO.INSTCD AND ATTD.VOLUNTRID = INFO.VOLUNTRID AND TO_CHAR(SYSDATE,'YYYYMMDD') >=INFO.ACTFROMDD AND TO_CHAR(SYSDATE,'YYYYMMDD') <=INFO.ACTTODD ) LEFT OUTER JOIN AST.AAAMVOTR VOTR ON( VOTR.VOLUNTRID = ATTD.VOLUNTRID AND VOTR.INSTCD = ATTD.INSTCD ) LEFT OUTER JOIN AST.AAAMEDUCFEST FEST ON( FEST.EDUCFESTIVSEQNO = ATTD.EDUCFESTIVSEQNO AND FEST.INSTCD =ATTD.INSTCD AND FEST.BIZFLAG='1' AND FEST.BIZFLAG=ATTD.BIZFLAG AND FEST.SERVTMRCOGFLAG='Y' AND ATTD.ATTDABSNFLAG IN('01','02') ) WHERE ATTD.VOLUNTRID='{?voluntrid}' AND ATTD.INSTCD='{?instcd}' AND ATTD.ACTRGSTSEQNO=INFO.ACTRGSTSEQNO UNION ALL SELECT ABSN.SERVDD AS ENTRYDD , ABSN.SERVTM AS EDUCRCOGTM , VOTR.SPCVOLUNTRFILD AS SPCVOLUNTRFILD , ABSN.ATTDABSNFLAG FROM AST.AAAHATTDABSN ABSN LEFT OUTER JOIN AST.AAAMVOTR VOTR ON (VOTR.VOLUNTRID=ABSN.VOLUNTRID AND VOTR.INSTCD=ABSN.INSTCD ) LEFT OUTER JOIN AST.AAAHACTINFO INFO ON ( INFO.VOLUNTRID=ABSN.VOLUNTRID AND INFO.INSTCD =ABSN.INSTCD AND TO_CHAR(SYSDATE,'YYYYMMDD') >= INFO.ACTFROMDD AND TO_CHAR(SYSDATE,'YYYYMMDD') <= INFO.ACTTODD ) WHERE ABSN.VOLUNTRID='{?voluntrid}' AND ABSN.INSTCD='{?instcd}' AND INFO.ACTRGSTSEQNO = ABSN.ACTRGSTSEQNO AND ABSN.ATTDABSNFLAG IN('01','02') )TMP GROUP BY TMP.SPCVOLUNTRFILD