¼òµ¥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)