sql结果集合并用union all 不同表的列合并用join

    结果集合并用union all 不同表的列合并用join

SELECT
"模块名",
"事件编码",
"点击数量",
"使用时长（单位：分）"
FROM

(SELECT 
T.fun_name as "模块名",
T.event_code as "事件编码",
SUM(click_records) as "点击数量"
FROM  
(SELECT m.* FROM default.daily_new_clientrpt_master m WHERE event_id in ( SELECT  max(event_id) AS "事件" from default.daily_new_clientrpt_master group by user_name,fun_code ORDER BY "事件" DESC ) ) T   where  day  = today() GROUP BY "模块名" ,"事件编码") T5
JOIN
(
SELECT 
T.fun_name as "模块名",
T.event_code as "事件编码",
round(sum(stay_time)/60000,0) as "使用时长（单位：分）"
FROM  
(SELECT m.* FROM default.daily_new_clientrpt_master m WHERE event_id in 
 ( 
   SELECT "事件" FROM (
   SELECT  max(event_id) AS "事件", max(stay_time) AS "事件1" from default.daily_new_clientrpt_master group by user_name,fun_code  ORDER BY "事件1" DESC) )
 
)  
 T   where  day  = today() AND like(event_code,'%10000')  GROUP BY "模块名" ,"事件编码"
) T6 ON T5."模块名"=T6."模块名" AND T5."事件编码"=T6."事件编码"