select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj,sum(sqjcsl),sum(sqjcdw),sum(bqrksl),sum(bqrkdw),sum(bqcksl),
sum(bqckdw),sum(bqjcsl),sum(bqjcdw) from
(
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj ,sum(kcsw_rksl)-sum(kcsw_cksl) as sqjcsl ,sum(kcsw_rkdw)-sum(kcsw_rkdw) as sqjcdw, 0 as bqrksl,0 as bqrkdw,0 as bqcksl,0 as bqckdw,0 as bqjcsl,0 as bqjcdw
from kcsw ,wl where kcsw_wlid=wl_wlid and kcsw_jzrq <'20041219' group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj
union all
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj,0 as sqjcsl,0 as sqjcdw,sum(kcsw_rksl) as bqrksl,sum(kcsw_rkdw) as bqrkdw ,sum(kcsw_cksl) as bqcksl,sum(kcsw_ckdw) as bqckdw,0 as bqjcsl,0 as bqjcdw
from kcsw ,wl where kcsw_wlid=wl_wlid and kcsw_jzrq between '20041220' and '20041220'
group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj
union all
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj ,0 as sqjcsl,0 as sqjcdw,0 as bqrksl,0 as bqrkdw,0 as bqcksl,0 as bqckdw ,sum(kcsw_rksl)-sum(kcsw_cksl) as bqjcsl ,sum(kcsw_rkdw)-sum(kcsw_ckdw) as bqjcdw
from kcsw ,wl where kcsw_wlid=wl_wlid and kcsw_jzrq <='20041220' group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj
) a
group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj要把以上查询语句指定到adodc1.recordsource中,该怎么写啊?
sum(bqckdw),sum(bqjcsl),sum(bqjcdw) from
(
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj ,sum(kcsw_rksl)-sum(kcsw_cksl) as sqjcsl ,sum(kcsw_rkdw)-sum(kcsw_rkdw) as sqjcdw, 0 as bqrksl,0 as bqrkdw,0 as bqcksl,0 as bqckdw,0 as bqjcsl,0 as bqjcdw
from kcsw ,wl where kcsw_wlid=wl_wlid and kcsw_jzrq <'20041219' group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj
union all
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj,0 as sqjcsl,0 as sqjcdw,sum(kcsw_rksl) as bqrksl,sum(kcsw_rkdw) as bqrkdw ,sum(kcsw_cksl) as bqcksl,sum(kcsw_ckdw) as bqckdw,0 as bqjcsl,0 as bqjcdw
from kcsw ,wl where kcsw_wlid=wl_wlid and kcsw_jzrq between '20041220' and '20041220'
group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj
union all
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj ,0 as sqjcsl,0 as sqjcdw,0 as bqrksl,0 as bqrkdw,0 as bqcksl,0 as bqckdw ,sum(kcsw_rksl)-sum(kcsw_cksl) as bqjcsl ,sum(kcsw_rkdw)-sum(kcsw_ckdw) as bqjcdw
from kcsw ,wl where kcsw_wlid=wl_wlid and kcsw_jzrq <='20041220' group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj
) a
group by wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj要把以上查询语句指定到adodc1.recordsource中,该怎么写啊?
解决方案 »
- GetCursorpos的API定义(求教高手)
- VB+SQLserver2005开发系统
- 怎样正确地引用OFFICE?
- 找一个能够显示系统所有磁盘的控件
- 简单的条件语句问题不知道有哪个大哥能帮我改下
- 有北京的朋友吗?25号左右去北京玩两天
- vb中运行SQL语句
- access问题,打印报表和数据库操作的数据环境怎么设置,(需要设置两个数据环境么),另
- 请教在form_load里对某一控件调用了zorder方法以后引起死循环怎么办
- 交通信息管理GIS系统设计
- 各位大侠!!VB+Crystal Repor8.5+ACCess2000做报表,在预览状态时出错,请问那一位知道原因呢?急!
- 请教应该用什么控件做课程表比较适合
(bqrksl),sum(bqrkdw),sum(bqcksl), & _
sum(bqckdw),sum(bqjcsl),sum(bqjcdw) from & _
以下类推。
SQL = SQL & " SELECT * "
SQL = SQL & " FROM TABLE1"
SQL = SQL & " WHERE COL1 = 'AA'"
select wl_wlid,kcsw_ph,wl_mc,wl_gg,wl_cz,wl_dj,sum(sqjcsl),sum(sqjcdw),sum & _
(bqrksl),sum(bqrkdw),sum(bqcksl), & _
sum(bqckdw),sum(bqjcsl),sum(bqjcdw) from & _
以下类推。如实在很长,还是这样用好,不然还会揭示很长:Dim sql As String
sql =""
sql = sql & " SELECT * "
sql = sql & " FROM TABLE1"
sql = sql & " WHERE COL1 = 'AA'"