select A.IPCH_DATE, A.IPCH_GUBN, A.IPCH_COST, A.IPGM_COST, A.CHUL_COST, 0 as COST_QNTY, A.MEMO_XXXX
--일자 구분 전일잔고 입금 출금 잔액 비고
from (
---------------------------------------전일 이전잔고
select IPCH_DATE, IPCH_GUBN, sum(isnull(IPCH_COST,0)) as IPCH_COST, 0 as IPGM_COST, 0 as CHUL_COST, 0 as COST_QNTY, ''as MEMO_XXXX
from(
select IPCH_DATE, IPCH_GUBN, sum(isnull(COST_QNTY, 0)) as IPCH_COST
from COST_INFO
where IPCH_GUBN ='1'
group by IPCH_DATE, IPCH_GUBN
union all
--전일 입금액-
select IPCH_DATE, IPCH_GUBN, sum(isnull(IPGM_COST, 0)) as IPCH_COST
from IPCH_INFO
where IPCH_DATE < '20140201'
and IPCH_GUBN ='1'
group by IPCH_DATE, IPCH_GUBN
--전일 입금 끝-
union all
--전일 출금액-
select IPCH_DATE, IPCH_GUBN, sum(isnull(CHUL_COST * (-1), 0)) as IPCH_COST
from IPCH_INFO
where IPCH_DATE <'20140201'
and IPCH_GUBN ='1'
group by IPCH_DATE, IPCH_GUBN
--전일 출금 끝-
) as A
group by IPCH_DATE, IPCH_GUBN
having sum(isnull(IPCH_COST,0)) <> 0
--------------------------------------전일 이전잔고 끝
union all
--당일 입금액--
select IPCH_DATE, IPCH_GUBN, sum(isnull(IPGM_COST,0)) as IPGM_COST
from IPCH_INFO
where IPCH_DATE = '20140201'
group by IPCH_DATE, IPCH_GUBN
--당일 입금 끝--
union all
--당일 출금액--
select IPCH_DATE, IPCH_GUBN, sum(isnull(CHUL_COST * (-1),0)) as CHUL_COST
from IPCH_INFO
where IPCH_DATE ='20140201'
group by IPCH_DATE, IPCH_GUBN
--당일 출금 끝--
)as A
장부 만들구 있는데요
어찌어찌 당일,전일 입출금 잔액까지 구하기는 했습니다.
문제는 1번줄에 select 문인데요.
제가 리스트에 표시할 칼럼들이거든요.
제가 형식을 잘못이해하고 있는 것 같은데 뭐가 문제인지 모르겠습니다.
ㅠㅠ 오늘 퇴근할 수 있게 도와주세요~!
글쓰기