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

jiangqinggao 2009-07-12 06:25:15
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 为相同的只显示一行,数量累加

请大家指教下。
...全文
96 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
jiangqinggao 2009-07-14
  • 打赏
  • 举报
回复
Yeah.. 强人那。
百年树人 2009-07-12
  • 打赏
  • 举报
回复
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]

56,940

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧