求教sql server的多表联查问题,跪求跪求太难了

nono26 2020-09-12 10:51:52
如图…join和group by我只会关联1个产品,再联仓库和渠道我脑子就懵了,浆糊… 求指点!!!
要做报表,大概如下图:

这是我单独关联产品的代码:
...全文
207 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
nono26 2020-09-17
  • 打赏
  • 举报
回复
花了好长时间终于搞明白了多表联查到底是个什么玩意_(:з」∠)_ 学习才是源动力
nono26 2020-09-14
  • 打赏
  • 举报
回复
nono26 2020-09-14
  • 打赏
  • 举报
回复
仓库和渠道弄出来了… 但数据为什么没有呢… 已经录入有数据了

select 
ws.cNCCode bandNCCode,
ws.cNCName bandNCName,
ws.cSpecs  bandSpecs,
ws.cModel  bandModel,
ws.cUnit   bandUnit,
ww.cWareName bandWareName,
wc.cChannelName bandChannelName,
ISNULL(dr.今日入库 ,0) inToday,
ISNULL(dc.今日出库 ,0) outToday
from WI_SteelNC ws

left join 
(select s.pk_steelNC,h1.pk_warehouse,h1.pk_channel,SUM(CONVERT(decimal(19,2),b1.fTotalWeight)) AS 今日入库 
from WI_SteelNC s
left join EV_InStock_b b1 on b1.pk_steelNC = s.pk_steelNC
left join EV_InStock_h h1 on h1.IShId = b1.ISbId
left join WI_WareHouse w1 on w1.pk_warehouse = h1.pk_warehouse 
left join WI_Channel c1 on c1.pk_channel = h1.pk_channel
where datediff(day,CONVERT(datetime,h1.dNewDate,120),CONVERT(datetime,'2020-09-14 17:20:52.837',120))=0 and h1.iState !=2
group by s.pk_steelNC,h1.pk_warehouse,h1.pk_channel)
dr on dr.pk_steelNC = ws.pk_steelNC

left join 
(select s.pk_steelNC,h2.pk_warehouse,h2.pk_channel,SUM(CONVERT(decimal(19,2),b2.fTotalWeight)) AS 今日出库 
from WI_SteelNC s
left join EV_SaleWZ_b b2 on b2.pk_steelNC = s.pk_steelNC
left join EV_SaleWZ_h h2 on h2.WZhId = b2.WZhId
left join WI_WareHouse w1 on w1.pk_warehouse = h2.pk_warehouse 
left join WI_Channel c1 on c1.pk_channel = h2.pk_channel
where datediff(day,CONVERT(datetime,h2.dNewDate,120),CONVERT(datetime,'2020-09-14 17:20:52.837',120))=0 and h2.iState !=2
group by s.pk_steelNC,h2.pk_warehouse,h2.pk_channel)
dc on dc.pk_steelNC = ws.pk_steelNC

left join WB_StockNC wsn on wsn.pk_steelNC = ws.pk_steelNC
left join WI_WareHouse ww on ww.pk_warehouse = wsn.pk_warehouse
left join WI_Channel wc on wc.pk_channel = wsn.pk_channel
order by ws.pk_steelNC,ww.pk_warehouse,wc.pk_channel

22,300

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

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