我的SQL语句是这样的,希望大家帮助分析!!!!
SELECT a.ID,
a.Des,
sum(c.Tprice )
FROM aaa as a,
bbb as b,
ccc as c
WHERE ( b.InvoiceID = c.InvoiceID )
and a.inserial=:inserial
and c.dfcode like a.id +'%'
and len(a.id)=1
group by a.id,a.des
union
SELECT aa.fairID,
aa.fairDes,
sum(bb.Tprice )
FROM ccc as aa,
ddd as bb,
eee as cc
WHERE ( bb.InvoiceID = cc.InvoiceID )
and cc.inserial=:inserial
and bb.dfcode like aa.fairid +'%'
and len(aa.fairid)=3
group by aa.fairid,aa.fairdes