select '库存合同未开票情况',
a.trackopcodename as '用户名',a.stockno as '采购合同号',p.goodscname as '产品名称',p.goodscode as '产品编码',p.custgoodscode as '客户货号',p.goodsnum as '采购数量',p.[其它.供应商简称] as '采购工厂',r.noticeno as '开票单号',SUM (o.goodsamount) as '已开票数量',s.instoreno as '入库单号',SUM (d.[其它.整批合格数量])as '入库合格数量',SUM (d.[其它.送检数量]) as '入库数量'
from csidbo.VS_Stock_Product p --采购明细表 pright join csidbo.vs_Stock a on a.id=p.stockid --采购主表 aright join csidbo.vs_BillNotice_Product o on p.stockid =o.stockid and p.productid = o.productid--开票明细表 oright join csidbo.vs_BillNotice_Report r on o.noticeid=r.id --开票主表 rright join csidbo.vs_StockInStore_Product d on p.stockid =d.stockid and p.productid =d.productid--采购入库明细表 dright join csidbo.vs_StockInStore s on d.instoreid=s.id --采购入库主表 s
where a.TrackOpCodeName = '禾荷-s'and a.stockno = '193036021'and r.producername != '上海对外经济贸易实业浦东有限公司'and s.status = 0and r.status = 0and a.status = 0
group by a.trackopcodename,a.stockno,p.goodscname,p.goodscode,p.custgoodscode,p.goodsnum,p.[其它.供应商简称],o.goodsamount,--r.noticeno,--s.instoreno,d.[其它.整批合格数量],d.[其它.送检数量]
order byp.goodscode
SQL查询出来 因为开票单号、入库单号不一致导致分行了
希望能够合并，即同一个合同号，同一个产品能够开票数量合并，入库数量合并（不需要显示开票单号和入库单号）

sum