Select a.fh,a.xm,a.xb,a.rzrq,
sum(b.je), sum(c.je)
from
yesjk a, krfkls b, krxfqd c
where a.rzdh=b.rzdh
and b.rzdh=c.rzdh <<!!! ---> a.rzdh=c.rzdh !!! recylic relationship!!!>>
and b.rq=:rq
and c.rq=:ii
group by a.fh,a.xm, a.xb, ar.rzrq (!!! use Group by for sum operation)
sum(b.je), sum(c.je)
from
yesjk a, krfkls b, krxfqd c
where a.rzdh=b.rzdh
and b.rzdh=c.rzdh <<!!! ---> a.rzdh=c.rzdh !!! recylic relationship!!!>>
and b.rq=:rq
and c.rq=:ii
group by a.fh,a.xm, a.xb, ar.rzrq (!!! use Group by for sum operation)
解决方案 »
- 求算两个日期间隔几年几月几日的函数
- [Error] dlzpas.pas(106): Cannot assign to a read-only property 什么意思
- 数据导入
- Delphi 三层中如何把SQL 语句写在中间层?
- 急,急,请问在win2003中配置DCOM,同在win2000下面有什么区别,请各位指点?
- 马上可结:数组赋值时为何出错呀
- 请问如何用Delphi捕获BED错误
- 为什么我在组件管理其中的事务属性中选上需要事务或者需要新事物时服务器就没反应?
- 做的发邮件程序发送的邮件是乱码,怎么办
- Guid--我们自己生成!!!进来看看有分儿拿。
- 字体大小设置问题,请各位高手帮忙
- 欢迎测试这个软件
look:
select a.fh,a.xm,a.xb,a.rzrq ,a.bz,sum(b.je),sum(c.je)
from yesjk a,krfkls b,krxfqd c
where b.rq=:rq and c.rq=:ii and a.rzdh=b.rzdh and b.rzdh=c.rzdh and a.rzdh=c.rzdh and b.fklx=1
group by a.fh,a.xm,a.xb,a.rzrq,a.bz,
order by a.fh,a.xm,a.xb,a.rzrq,a.bz