select hph,ckh,rq,cksl=Sum(case when djName = 'ck' then sl,else 0 end),
...
(
select hph,sl,ck_ckh as ckh,ck_rq as rq,'ck' as djName from ckd
union all
select hph,sl,rk_ckh as ckh,rk_rq as rq,'rk' as djName from rkd
union all
...
) a
group by a.hph.a.ckh,a.rq
...
(
select hph,sl,ck_ckh as ckh,ck_rq as rq,'ck' as djName from ckd
union all
select hph,sl,rk_ckh as ckh,rk_rq as rq,'rk' as djName from rkd
union all
...
) a
group by a.hph.a.ckh,a.rq
解决方案 »
- 在线等,,请教大家一个问题,,急急急
- 小弟在这里问一个关于利用查询分析器新建表的问题,希望高手帮忙!~
- 请教SQL脚本的高手,如何给我们网站的会员系统的USER表通过执行SQL脚本增加生成1000系随机的用户ID和密码呢?
- 如何将多行合成一行的SQL问题,`想请教请教!
- 删除表中前20条记录的SQL语句怎么写?
- 各位大虾们,求一个sql语句,急!
- asp中用ado连接sql server数据库
- 这个能用SQL完成吗????
- 100分:你敢把这个SQL语句写出来不?!
- 有谁知道SQL7.0中关于MAIL部分?
- 使用Provider=Microsoft.Jet.OLEDB.4.0 这个,需要ADO还是DAO的安装引擎?
- 在线等待回音 SQL Server远程访问的问题
怎么回事?
rksl=Sum(case when lgf='rk' then sl,else 0 end),
thsl=Sum(case when lgf='th' then sl,else 0 end),
hhsl=Sum(case when lgf='hh' then sl,else 0 end)
from
(select mx.hph,mx.sl,mx.pzh,ckd.ck_ckh,ckd_.ck_rq,lgf='ck' from mx,ckd where mx.pzh=ckd.ck_pzh
union
select mx.hph,mx.sl,mx.pzh,rkd.ck_rkh,rkd.rk_rq,lgf='rk' from mx,rkd where mx.pzh=ckd.rk_pzh
union
select mx.hph,mx.sl,mx.pzh,thd.th_thh,thd.th_rq,lgf='th' from mx,thd where mx.pzh=ckd.th_pzh
union
select mx.hph,mx.sl,mx.pzh,rkd.hh_hhh,hhd.hh_rq,lgf='hh' from mx,hhd where mx.pzh=ckd.hh_pzh) tb1
group by hph,ckh,rq