>SELECT obligat.obligor, obligat.obligation, MIN(obligat.unit), MIN(obligat.name), MIN(obligat.loantype), ; > MIN(obligat.lot), MIN(obligat.block), MIN(obligat.phase_unit), MIN(obligat.subdivsn), ; > sum(disbtmp.loan_disb) as loan_disb, sum(disbtmp.inspfedisb) as inspfedisb,; > MIN(obligat.inspfemoc), MIN(obligat.inspfecoll), MIN(obligat.inspfeincl), MIN(obligat.inspfeused),; > sum(disbtmp.inspfetday) as inspfetday, sum(disbtmp.loan_fees) as loan_fees,; > sum(disbtmp.disbddaamt) as disbddaamt; > FROM obligat, disbtmp, obligor INTO table (rpt013b) ; > WHERE disbtmp.obligor + disbtmp.obligation + disbtmp.unit =; > obligat.obligor + obligat.obligation + obligat.unit; > AND obligor.obligor = obligat.obligor ; > AND disbtmp.loan_disb > 0; > GROUP BY obligat.obligor, obligat.obligation ; > ORDER BY obligat.name, obligat.obligor, obligat.subdivsn, obligat.phase_unit, ; > obligat.block, obligat.lot, obligat.obligation, obligat.unit > >
ORDER BY ; 4 ; , obligat.obligor; , obligat.subdivsn; , 9 ; , 7 ; , 6 ; , obligat.obligation; , 3