我有两张桌子。
“表_1”，其中包含一些基本数据：
表_1
“表_2”中包含原始数据：
表_2
I'd like to be able to SUM '表_2.Qty' into '表_1' where the row level fields match up.
我尝试了以下代码来获取这些数据，但我似乎忽略了案例中包含的一些或大部分行，从而得到了一个总计？
SELECT
[Table_1].[SKU]
,[Table_1].[StoreID]
,[Table_1].[Week]
,[Table_1].[Year]
,SUM(CASE WHEN
[Table_2].[SKU] = [Table_1].[SKU]
AND
[Table_2].[StoreID] = [Table_1].[StoreID]
AND
[Table_2].[Week] = [Table_1].[Week]
AND
[Table_2].[Year] = [Table_1].[Year]
THEN [Table_2].[qty]
ELSE 0
END)
AS "Qty Ordered"
FROM [Table_1]
INNER JOIN [Table_2] ON
[Table_2].[SKU] = [Table_1].[SKU]
AND
[Table_2].[StoreID] = [Table_1].[StoreID]
AND
[Table_2].[Week] = [Table_1].[Week]
AND
[Table_2].[Year] = [Table_1].[Year]
GROUP BY [Table_1].[SKU]
,[Table_1].[StoreID]
,[Table_1].[Week]
,[Table_1].[Year];
请提供任何指针帮助。
对不起，我不知道如何在我的问题中适当地添加一个表。
谢谢