도움부탁드립니다
,COUNT(*) TOT_CNT 총건수랑 밑에부에 ------- 줄되어있는 부분을 추가하려고 하는데
DB2 Database Error: ERROR [42703] [IBM][DB2/HP64] SQL0206N "TOT_CNT" is not valid in the context where it is used. SQLSTATE=42703
에러가 나오네여 ㅜ.ㅜ 도와주세여
이부분쿼리에 ------- 를 추가하려고 합니다
SELECT A.TRN_DT
,A.TRBR_CD
,B.KBR_NM TRBR_NM
--,COUNT(SQ1_FIX_TM) TOT_CNT
,COUNT(*) TOT_CNT
,SUM(CTR_FIX_DSCD) CTR_FIX_DSCD
,SUM(SQ1_FIX_DT) SQ1_FIX_DT
,SUM(SQ1_XCP_DT) SQ1_XCP_DT
,A.SQ1_FIX_TM
,A.SQ1_XCP_TM
,A.OPR_NM
,A.OPR_NM OPR_NM2
,B.TEL_NO
,SUM(SQ2_FIX_DT) SQ2_FIX_DT
,SUM(SQ2_XCP_DT) SQ2_XCP_DT
FROM (SELECT TRN_DT
,TRBR_CD
,CASE WHEN CTR_FIX_DSCD ='00' THEN 0 ELSE 1 END CTR_FIX_DSCD
,CASE WHEN SQ1_FIX_DT IS NULL OR SQ1_FIX_DT = '' THEN 0 ELSE 1 END SQ1_FIX_DT
,CASE WHEN SQ1_XCP_DT IS NULL OR SQ1_XCP_DT = '' THEN 1 ELSE 0 END SQ1_XCP_DT
,SQ1_FIX_TM
,SQ1_XCP_TM
,OPR_NM
,CASE WHEN SQ2_FIX_DT IS NULL OR SQ2_FIX_DT = '' THEN 0 ELSE 1 END SQ2_FIX_DT
,CASE WHEN SQ2_XCP_DT IS NULL OR SQ2_XCP_DT = '' THEN 1 ELSE 0 END SQ2_XCP_DT
FROM AMLRT553
) A
,AMLRT058 B
where b.br_cd = a.trbr_cd
GROUP BY A.TRN_DT, A.TRBR_CD, B.KBR_NM, A.CTR_FIX_DSCD, A.SQ1_FIX_TM, A.SQ1_XCP_TM, A.OPR_NM, B.TEL_NO
----------------------------------------------------------------------------
,CASE WHEN SUM(SQ1_FIX_DT) + SUM(SQ1_XCP_DT) = SUM(SQ1_FIX_DT) AND SUM(SQ1_XCP_TM) > TRN_DT + 1 AND SUM(SQ2_FIX_DT) + SUM(SQ2_XCP_DT) < SUM(SQ1_FIX_DT) THEN '1차지연'
WHEN SUM(SQ1_FIX_DT) + SUM(SQ1_XCP_DT) = SUM(SQ1_FIX_DT) AND SUM(SQ1_XCP_TM) > TRN_DT + 1 AND SUM(SQ2_FIX_DT) + SUM(SQ2_XCP_DT) = SUM(SQ1_FIX_DT) THEN '1차지연-2차완료'
WHEN SUM(SQ1_FIX_DT) + SUM(SQ1_XCP_DT) < SUM(SQ1_FIX_DT) AND SUM(SQ1_XCP_TM) < TRN_DT + 1 THEN '1차미완료'
WHEN SUM(SQ1_FIX_DT) + SUM(SQ1_XCP_DT) < SUM(SQ1_FIX_DT) AND SUM(SQ1_XCP_TM) = TRN_DT + 1 THEN '1차미완료-2차완료'
WHEN SUM(SQ1_FIX_DT) + SUM(SQ1_XCP_DT) = SUM(SQ1_FIX_DT) AND SUM(SQ1_XCP_TM) < TRN_DT + 1 THEN '1차완료'
WHEN SUM(SQ1_FIX_DT) + SUM(SQ1_XCP_DT) = SUM(SQ1_FIX_DT) AND SUM(SQ1_XCP_TM) = TRN_DT + 1 THEN '1차완료-2차완료' ELSE '모두진행중' END EXT_TXT
---------------------------------------------------------------------------
|