有点甜老师,帮我看下这个代码。【纵向分析的表】
为什么 每日总销售额.包含非VIP客户的总销售 不对呢?
SELECT VIP客户消费明细.购买日期 AS "VIP客户消费明细 购买日期", SUM(VIP客户消费明细.金额) AS "VIP客户消费明细 金额 Sum", COUNT(DISTINCT VIP客户消费明细.VIP客户卡号) AS "VIP客户消费明细 VIP客户卡号 Distinct count", SUM(VIP客户消费明细.数量) AS "VIP客户消费明细 数量 Sum", SUM(每日总销售额.包含非VIP客户的总销售) AS "每日总销售额 包含非VIP客户的总销售 Sum"
FROM (sql42988.VIP客户消费明细 AS VIP客户消费明细
INNER JOIN sql42988.每日总销售额 AS 每日总销售额 ON (VIP客户消费明细._Identify = 每日总销售额._Identify ))
WHERE
(
VIP客户消费明细.门店 = '门店1' )
GROUP BY VIP客户消费明细.购买日期
ORDER BY 1, 2