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 为相同的只显示一行,数量累加 请大家指教下。
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 为相同的只显示一行,数量累加 请大家指教下。
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]