简单SQL语法

SELECT A.barcode, A.number, B.goodsname
from pandian AS A INNER JOIN
      baseinfo AS B ON A.barcode = B.barcode


现在：
4961557110306 1 Elsan  Bath chanm浴盐(森林)
4961557110306 10 Elsan  Bath chanm浴盐(森林)
4961557011221 20 Elsan Bat hchanm浴盐(柠檬)

要求：


4961557110306 11 Elsan  Bath chanm浴盐(森林)
4961557011221 20 Elsan Bat hchanm浴盐(柠檬)


怎么写、？

---

SELECT A.barcode, max(A.number) number, B.goodsname
from pandian AS A INNER JOIN
baseinfo AS B ON A.barcode = B.barcode
group by A.barcode, B.goodsname

---

SQL code:
SELECT A.barcode, sum(A.number) as [number] , B.goodsname
from pandian AS A INNER JOIN
baseinfo AS B ON A.barcode = B.barcode
group by A.barcode,B.goodsname

---

引用

SELECT A.barcode, max(A.number) number, B.goodsname
from pandian AS A INNER JOIN
baseinfo AS B ON A.barcode = B.barcode
group by A.barcode, B.goodsname

是sum 呵呵

---

SQL code:

declare @pandian table (barcode bigint,number int)