아래의 쿼리를 한 번으로 줄일 수 있는 방법이 없을까요?
---------------------------------------------------------------------
select count(*) AS CNT_CHULSUK -- 출석 인원
INTO CNT_CHULSUK
from AP_CURRENT_MGR CM INNER JOIN AP_ATTENDANCE AT
ON CM.Session_Cd = AT.Session_Cd
AND CM.Currents_CD = AT.Currents_CD
AND CM.Currents_Kind = AT.Currents_Kind
where ATTEND_KIND = '1'
;
select count(*) AS CNT_GYEOLSUK -- 결석 인원
INTO CNT_GYEOLSUK
from AP_CURRENT_MGR CM INNER JOIN AP_ATTENDANCE AT
ON CM.Session_Cd = AT.Session_Cd
AND CM.Currents_CD = AT.Currents_CD
AND CM.Currents_Kind = AT.Currents_Kind
where ATTEND_KIND = '0'
;
select count(*) AS CNT_CHUNGGA -- 청가 인원
INTO CNT_CHUNGGA
from AP_CURRENT_MGR CM INNER JOIN AP_ATTENDANCE AT
ON CM.Session_Cd = AT.Session_Cd
AND CM.Currents_CD = AT.Currents_CD
AND CM.Currents_Kind = AT.Currents_Kind
where ATTEND_KIND = '2'
;
select count(*) AS CNT_CHULJANG -- 출장 인원
INTO CNT_CHULJANG
from AP_CURRENT_MGR CM INNER JOIN AP_ATTENDANCE AT
ON CM.Session_Cd = AT.Session_Cd
AND CM.Currents_CD = AT.Currents_CD
AND CM.Currents_Kind = AT.Currents_Kind
where ATTEND_KIND = '3'
;
select count(*) AS CNT_GYEOLSUK2 -- 결석계 인원
INTO CNT_GYEOLSUK2
from AP_CURRENT_MGR CM INNER JOIN AP_ATTENDANCE AT
ON CM.Session_Cd = AT.Session_Cd
AND CM.Currents_CD = AT.Currents_CD
AND CM.Currents_Kind = AT.Currents_Kind
where ATTEND_KIND = '4'
;