主题：多表查询统计

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