select
b.vdSubid,
vdBorrow = sum(b.vdBorrow),
vdLend =sum(b.vdLend)
from
bSubject a,
tVoucherdet b
where
a.subClass <= [N] and b.vdSubid like a.subId+'%' --此处的N即级别编号
group by
b.vdSubid
order by
b.vdSubid
b.vdSubid,
vdBorrow = sum(b.vdBorrow),
vdLend =sum(b.vdLend)
from
bSubject a,
tVoucherdet b
where
a.subClass <= [N] and b.vdSubid like a.subId+'%' --此处的N即级别编号
group by
b.vdSubid
order by
b.vdSubid
vdSubid vdBorrow vdLend
101 1000
10101 1000
102 9000
10201 9000
1020101 1000
1020102 8000
203 5200
204 2800to libin_ftsafe(子陌红尘):
谢谢你!
能不能再修改一下,还有你上面的代码应该是这样子的:
select
a.Subid,
vdBorrow = sum(b.vdBorrow),
vdLend =sum(b.vdLend)
from
bSubject a,
tVoucherdet b
where
a.subClass <= [N] and b.vdSubid like a.subId+'%' --此处的N即级别编号
group by
a.Subid
order by
a.Subid