56,940
社区成员




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]