求助mysql如何将这3张表的结果整合起来输出

Question

• 表一：cg_event_solved_statistics_day
  

  SELECT
    event_num AS event_solved_num,
    day_huanbi_rate AS solved_huanbi_rate,
    day_tongbi_rate AS solved_tongbi_rate 
  FROM
    cg_event_solved_statistics_day 
  WHERE
    event_day = DATE_FORMAT( now(), '%Y-%m-%d' ) 

  

• 表二：cg_event_total_statistics_day
  

  SELECT
    event_num AS event_total_num,
    day_huanbi_rate AS total_huanbi_rate,
    day_tongbi_rate AS total_tongbi_rate 
  FROM
    cg_event_total_statistics_day 
  WHERE
    event_day = DATE_FORMAT( now(), '%Y-%m-%d' ) 

  

• 表三：cg_event_pending_statistics_day
  

  SELECT
    event_num AS event_pending_num,
    day_huanbi_rate AS pending_huanbi_rate,
    day_tongbi_rate AS pending_tongbi_rate 
  FROM
    cg_event_pending_statistics_day 
  WHERE
    event_day = DATE_FORMAT( now(), '%Y-%m-%d' )

  

单个查询没问题，我想怎么把上面的3个单次查询的结果整合为一个输出呢？
我是这么写的，但是结果都是null

SELECT
    * 
FROM
    ( SELECT event_num AS event_total_num, day_huanbi_rate AS total_huanbi_rate, day_tongbi_rate AS total_tongbi_rate FROM cg_event_total_statistics_day WHERE event_day = DATE_FORMAT( now(), '%Y-%m-%d' ) ) total,
    ( SELECT event_num AS event_pending_num, day_huanbi_rate AS pending_huanbi_rate, day_tongbi_rate AS pending_tongbi_rate FROM cg_event_pending_statistics_day WHERE event_day = DATE_FORMAT( now(), '%Y-%m-%d' ) ) pending,
    ( SELECT event_num event_solved_num, day_huanbi_rate solved_huanbi_rate, day_tongbi_rate solved_tongbi_rate FROM cg_event_solved_statistics_day WHERE event_day = DATE_FORMAT( now(), '%Y-%m-%d' ) ) solved 

Answer 1

可以用union all
例如t1 union all t2 union all t3

Answer 2

这些表看起来没有关联，好像只能分开查询在代码里做插入了。
有种临时简历关联表的处理我没试过，你可以尝试下