【搞定】SQL问题**

happycpu · 发表于 2007-8-3 02:05:30

我要用什么SQL语句才能把这两个查询出来的数据合并到一起..

happycpu · 发表于 2007-8-3 02:06:13

得到下面效果

--------------------------------------------
项目时间合计累计
1 2 3 4
-------------------------------------------

lisb · 发表于 2007-8-3 09:34:46

select xm as '项目',sj as '时间',sum(hj) as '合计', sum(lj) as '累计'
from
(select xm,sj，sum(jrs-kss) as hj,0 as lj
from semxb
where ZBGUID in (select GUID from SERBZB) and TBRQ = '2007-08-01'
group by xm,sj
union
select xm,sj,0,sum(jrs-kss)
from semxb
where ZBGUID in (select GUID from SERBZB)
group by xm,sj) T1
group by xm,sj

happycpu · 发表于 2007-8-3 10:40:06

谢谢 ...可以的。..不知道哪儿有SQL的这些资料..

我用join 为什么不行?

lisb · 发表于 2007-8-3 10:53:30

资料网上应该很多。

crosbychina · 发表于 2007-8-3 11:04:03

用case 不好么？
select xm as '项目',sj as '时间',sum(jrs-kss) as '累计',sum(case when TBRQ = '2007-08-01' then jrs-kss else 0 end) as '累计'
from semxb
where ZBGUID in (select GUID from SERBZB)
group by xm,sj

lisb · 发表于 2007-8-3 11:08:56

自己看一下，哪个效率高用那个。

happycpu · 发表于 2007-8-3 13:03:15

好，真是感谢。。。可以结了

		自动登录	找回密码
密码			立即注册