sql server 数据显示问题，数量累加问题。

[jiangqinggao]

select DISTINCT D.UniCode as UniCode, A.bitcode as bitcode,C.StoreName as StoreName,A.bitvalues as bitvalues, A.states as states,D.ItemName as ItemName,
D.[Size] as [Size],B.amount as amount from JS_spaceCodeTbl A LEFT OUTER JOIN JS_OptspCodeList B on A.bitvalues =b.spvalues LEFT OUTER JOIN JS_StoreTbl c on
c.StoreID =a.StoreID left OUTER JOIN JS_SysItemTbl d on B.[unicode] = D.[unicode] where bitvalues ='1,1,1' and amount != 0



看下这个 句子，设计的表比较多。
得出数据如下


我想要的结果是。。
unicode 为相同的只显示一行，数量累加

请大家指教下。

[百年树人]

select 
  D.UniCode as UniCode,  
  A.bitcode as bitcode,
  C.StoreName as StoreName,
  A.bitvalues as bitvalues, 
  A.states as states, 
  D.ItemName as  ItemName, 
  D.[Size] as [Size],
  sum(B.amount) as amount  
from 
  JS_spaceCodeTbl A  
LEFT OUTER JOIN 
  JS_OptspCodeList B  
on 
  A.bitvalues =b.spvalues  
LEFT OUTER JOIN 
  JS_StoreTbl c 
on 
  c.StoreID =a.StoreID  
left OUTER JOIN 
  JS_SysItemTbl d  
on 
  B.[unicode] = D.[unicode]  
where
  bitvalues ='1,1,1' and amount != 0
group by
  D.UniCode,  
  A.bitcode,
  C.StoreName,
  A.bitvalues,  
  A.states,
  D.ItemName, 
  D.[Size]

[jiangqinggao]

Yeah.. 强人那。