简单SQL语句(15分)

say-rise · 2006-10-31

表a
A1 B1
AA 0
BB 0
CC 0
==================
表b
A2 B2
AA 1
AA 2
BB 3
BB 4
=====================
查询结果为
A1 B1
AA 3
BB 7
CC 0
=================
SQL语句怎么写？、

say-rise · 2006-10-31

================

gwy427 · 2006-10-31

晕啊 ,把你的意思用文字来表达一下吧

say-rise · 2006-10-31

对a表和b表进行查询，得出a表的第一个字段，和b表连接，得出后面的和值

dzl19 · 2006-10-31

select a2,sum(b2) from 表b group by a2
union select a1,sum(b1) from 表a group by a1 where a1 not in (select distinct a2 from 表b)
是否这个意思？
还是汇总的数据包括a1表的呢？

sefeng1982 · 2006-10-31

select 表a.a ,(表a.b+isnull(表b.b,0)) as b
from 表a left join 表b on 表a.a=表b.b
group by 表a.a

sefeng1982 · 2006-10-31

写错了

select 表a.a ,(表a.b+isnull(表b.b,0)) as b
from 表a left join 表b on 表a.a=表b.a
group by 表a.a

其实就是一个外连接, 把null 那个值置为 0 ,然后就可以相加了

HowCan · 2006-10-31

大家太麻烦了:
select 表a.a ,sum(isnull(表b.b,0)) as b
from 表a left join 表b on 表a.a=表b.a
group by 表a.a

sefeng1982 · 2006-10-31

哦,那我理解错 lz 的意思了.我以为后一个字是 a+b 的总和呢

楼上的明显就是抄我的,呵呵

say-rise · 2006-10-31

sefeng1982 · 2006-10-31

给分,呵呵

苏记豆浆 · 2006-10-31

select c.a2 名称, sum(c.d) 总和
from (select a2, sum(b2) d
from b
group by a2
union
select a1, sum(b1) from a group by a1) c
group by c.a2

名称总和
1 AA 4
2 BB 9
3 CC 3

say-rise · 2006-10-31

多人接受答案了。

简单SQL语句(15分)

say-rise

Unregistered / Unconfirmed

say-rise

Unregistered / Unconfirmed

gwy427

Unregistered / Unconfirmed

say-rise

Unregistered / Unconfirmed

dzl19

Unregistered / Unconfirmed

sefeng1982

Unregistered / Unconfirmed

sefeng1982

Unregistered / Unconfirmed

HowCan

Unregistered / Unconfirmed

sefeng1982

Unregistered / Unconfirmed

say-rise

Unregistered / Unconfirmed

sefeng1982

Unregistered / Unconfirmed

苏记豆浆

Unregistered / Unconfirmed

say-rise

Unregistered / Unconfirmed

Similar threads