Question

vb sql 查询如何汇总查询结果？？着急

SQL数据表X中的数据如下有批次：
编码 数量 批次
A 100 A1
B 50 B1
B 100 B2
先在想查询汇总出B的总和 b=150 写入到数据表y中（y表无批次）
求汇总写入的方法？？
不只是B，还有A，B，C，D……的总数？？
SQL = "SELECT * FROM x where 数量 <> 0 "
Set rs = Selectsql(SQL)
If Not rs.EOF Then
ReDim a(rs.RecordCount)
For k = 1 To rs.RecordCount
a(k) = rs.Fields("型号").Value & "" & "---" & rs.Fields("数量").Value & ""
rs.MoveNext
Print a(k)
Next k
如何累加 a（k）的数量，写入数据表y？？

Answer 1

SQL语句是：select sum(数量) into y from x where 编码='b'

查出编码为b的数量和 然后用into 插到y

Answer 2

insert into y( [编码],[数量]) select [编码],sum([数量]) from b1 where [编码]='B' group by [编码] having sum([数量])=150

Answer 3

SQL=“Select Sum(数量) into [数据表y] From x where 编码='B'”
cn.Excute SQL

追问

请看补充问题

Answer 4

insert into y
select x.编码, sum(x.数量) from x group by 编码