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

[nono26]

如图…join和group by我只会关联1个产品，再联仓库和渠道我脑子就懵了，浆糊… 求指点！！！
要做报表，大概如下图：

这是我单独关联产品的代码：

[nono26]

仓库和渠道弄出来了… 但数据为什么没有呢… 已经录入有数据了

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

[nono26]

[nono26]

花了好长时间终于搞明白了多表联查到底是个什么玩意_(:з」∠)_ 学习才是源动力