[求助]SQL统计语句

[okdiy]

有二张表大概表结构如下：
入库表：stock
产品ID 　　产品名　　　入库数量
productid productname number
1 AAA 2
1 AAA 2
2 BBB 4
出库表：out
产品ID 产品名 出库数量
　 1 AAA 3

我想得到库存表是
产品ID 产品名　　入库总数量 出库总数量 库存

1 AAA 　　4 3 1
请问这样的SQL统计语句怎么写？

[paoluo]

Select
A.productid As 产品ID,
A.productname As 产品名,
A.number As 入库总数量,
B.number As 出库总数量,
(A.number-B.number) As 库存
From
(Select productid,productname,SUM(number) As number From stock Group By productid,productname) A
Inner Join
(Select productid,SUM(number) As number From [out] Group By productid) B
On A.productid=B.productid

[gjz_1209]

来迟了，同意楼上。

[okdiy]

XX