select '0' cust_div,a.cust_cd,cust_nm,normal,
sum(dr) dr,
sum(cr) cr,
'1' gubun
from lsg5041 a,lfsgt100 b
where a.coop like substr('175410',1,5)||'%' and
act_cd in ('11','12') and
act_dt between substr('20011030',1,6)||'00' and '20011030' and
--a.cust_cd between from_cust and :to_cust and
a.cust_cd = b.cust_cd
group by a.cust_cd,a.normal,cust_nm