select f_period,ipgum ,outgum, thissum+
ifnull (
(
select thissum from
( SELECT (@NUM1 := @NUM1 + 1) AS num,ipgum-outgum as thissum
FROM customer,(SELECT @NUM1 := 0) R
) T
where T.num < A.num order by num desc
) , 0 ) AS total_num
from
(
SELECT (@NUM2 := @NUM2 + 1) AS num, f_period, ipgum , outgum, ipgum-outgum as thissum
FROM customer,(SELECT @NUM2 := 0) R order by f_period,sellnum
) A
테이블에 ip_num , outgum 이 입력이 되어있습니다.
[ total_num(잔액) 은 제외 ]
f_period ip_num outgum total_num(잔액)
09-03-01 222,000 0 222,000
09-03-02 0 100,000 111,000
근데 위의 쿼리문을 날리면 total_num(잔액)
나와야 하는데 데이타를 못 가지고 옵니다.
|