在线求助,查询问题

[tianyan316]

表TAB
有A,B列
数据如下
A B
1 2
1 4
3 5
2 8
3 2
_________
如何变成
A B
1 6
3 7
2 8
在ACCESS中实现

[-晴天]

select a, sum(b) into TAC from TAB group by a

[-晴天]

select a, sum(b)as b into TAC from TAB group by a

[tianyan316]

我在ACCESS行不通```我前面也这么试的``好像是那个SUM函数不行`还是怎么回事``

[tianyan316]

我电脑没装SQL现在要处理点数据```只有ACCESS`

郁闷``

[luzhide2008]

select A,B=sum(B) from TAB group by A

[dawugui]

[Quote=引用楼主 tianyan316 的帖子:]
表TAB
有A,B列
数据如下
A B
1 2
1 4
3 5
2 8
3 2
_________
如何变成
A B
1 6
3 7
2 8
在ACCESS中实现
[/Quote]
select A , sum(B) B from tab group by A

[hery2002]

declare @tb table(A int, B int)
insert into @tb
select 1,2
union all
select 1,4  
union all
select 3,5
union all
select 2,8
union all
select 3,2

select A ,B=sum(B) from @tb group by A order by B
/*
A           B
----------- -----------
1           6
3           7
2           8

(3 row(s) affected)


*/

[哈哈]

select A ,sum(B) as B from TAB group by A

Access 中测试通过

[tianyan316]

ACCESS不能用SUM函数
所以我不知道怎么弄``说什么要用DSUM但也老出错

[gaojie001]

select A,sum(B) from table group by A
给分呀