求SQL句的合并急在等
求SQL句的合并急在等:
我有表A表B
A(DOCid,Jobid,item_no,quantity)
B(item_no,item_desc)
select A.DOCid,A.Jobid,A.item_no,A.quantity,B.item_desc
from A INNER JOIN B on A.item_no=B.item_no
得到:
DOCid Jobid item_no quantity item_desc

DF001 PP001 E001 24 化01
DF002 PP001 E001 30 化01

在我想只得到DF002 DF001去掉但在DF002中quantity要加上DF002中的quantity想得到果是

DF002 PP001 E001 54 化01


急大家忙

[解决办法]
select A.DOCid,A.Jobid,A.item_no,SUM(A.quantity) As quantity,B.item_desc
from A INNER JOIN B on A.item_no=B.item_no
Group By A.DOCid,A.Jobid,A.item_no, B.item_desc

[解决办法]
看了

select Min(A.DOCid) As DOCid,A.Jobid,A.item_no,SUM(A.quantity) As quantity,B.item_desc
from A INNER JOIN B on A.item_no=B.item_no
Group By A.Jobid,A.item_no, B.item_desc