两个订单表 没有关联字段 现在想查询到 每天不同业务的销售金额统计

Question

Answer 1

select t.时间,sum(t.t) as 团购总计,sum(t.w) as 外卖总计 from (select 时间,支付金额 as t,0 as w from T_table union all select 时间,0,支付金额 from W_table) t group by t.时间;