UC知道sql语句，解释描述。。。。
来源：百度知道 编辑：UC知道 时间：2024/06/11 12:18:58
select a.year,
e.docname,
b.budgetmoney,
sum(nvl(d.nmoney, 0)),
(b.budgetmoney - sum(nvl(d.nmoney, 0)))
from bd_budget a,
bd_budgetdetail b,
(select h.taudittime, b.*
from po_praybill h, po_praybill_b b
where h.cpraybillid = b.cpraybillid
and h.ibillstatus in (1, 3)
and to_char(to_date(h.taudittime, 'YYYY,MM,DD,HH24,Mi,SS'),
'yyyy') = '2009'
and h.dr = 0
and b.dr = 0) d,
bd_defdoc e
where a.pk_budget = b.pk_budget
and a.year = '2009'
and b.taskno = e.pk_defdoc
and b.taskno = d.pk_defdoc2(+)
and a.dr = 0
and b.dr = 0
and e.docname='11015103'
group by a.year, e.docname, b.budgetmoney
order by a.year;
稍微有点乱，帮我解释一下这个语句可以么？
e.docname,
b.budgetmoney,
sum(nvl(d.nmoney, 0)),
(b.budgetmoney - sum(nvl(d.nmoney, 0)))
from bd_budget a,
bd_budgetdetail b,
(select h.taudittime, b.*
from po_praybill h, po_praybill_b b
where h.cpraybillid = b.cpraybillid
and h.ibillstatus in (1, 3)
and to_char(to_date(h.taudittime, 'YYYY,MM,DD,HH24,Mi,SS'),
'yyyy') = '2009'
and h.dr = 0
and b.dr = 0) d,
bd_defdoc e
where a.pk_budget = b.pk_budget
and a.year = '2009'
and b.taskno = e.pk_defdoc
and b.taskno = d.pk_defdoc2(+)
and a.dr = 0
and b.dr = 0
and e.docname='11015103'
group by a.year, e.docname, b.budgetmoney
order by a.year;
稍微有点乱，帮我解释一下这个语句可以么？
使用bd_budget a表的year排序,条件是 year = '2009'and b.taskno = e.pk_defdoc
and b.taskno = d.pk_defdoc2(+)
and a.dr = 0
and b.dr = 0
and e.docname='11015103'
，查询资源来自from a, b,h,e等几个表
再经过group by a.year, e.docname, b.budgetmoney
order by a.year; 排序
具体只有写这人会清楚了