日志

两张表分组查询之后合并表，合并两张表

2021-01-26

0 评论

3,163 阅读

正在检测是否收录...

01/26

两张表分组查询之后并且合并数据结果集，条件是两张表的查询结果字段需要一模一样，才能合并两张表

-- 两张表分组查询之后 再合并结果
SELECT * FROM ((SELECT SUM(money) total_money,agentid user_id FROM dcr_declaration GROUP BY agentid) a1 ) 
UNION ALL
SELECT * FROM ((SELECT SUM(agent_level_money) total_money,user_id FROM dcr_user_recommend_log GROUP BY user_id) a2 );


-- 两张表分组查询之后 再合并结果并且分组查询
SELECT SUM(total_money) total,user_id FROM
(
SELECT * FROM ((SELECT SUM(money) total_money,agentid user_id FROM dcr_declaration GROUP BY agentid) a1 ) 
UNION ALL
SELECT * FROM ((SELECT SUM(agent_level_money) total_money,user_id FROM dcr_user_recommend_log GROUP BY user_id) a2 )
) 
t_table GROUP BY user_id  ORDER BY total DESC LIMIT 10;