mysql拼接多张表数据

最新推荐文章于 2024-08-19 09:28:34 发布

Mr_ZhangAdd

最新推荐文章于 2024-08-19 09:28:34 发布

阅读量2.1k

点赞数

分类专栏： MySQL 文章标签： mysql elementui 蓝桥杯

本文链接：https://blog.csdn.net/Mr_ZhangAdd/article/details/122211762

版权

MySQL 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

SELECT 
  SUM(paid) AS sumCostPrice,
  DATE_FORMAT(createTime, '%Y-%m') AS createTimeFormate 
FROM
  `t_procurement_new` 
WHERE companyId = 39 
  AND createTime >= "2021-01-01" 
  AND createTime <= "2021-12-01" 
GROUP BY createTimeFormate 
UNION
ALL #报销 
SELECT 
  SUM(sumAppliedPrice) AS sumCostPrice,
  DATE_FORMAT(createDate, '%Y-%m') AS createTimeFormate 
FROM
  `t_order_goods_event_apply_log` 
WHERE companyId = 39 
  AND createDate >= "2021-01-01" 
  AND createDate <= "2021-12-31" 
GROUP BY createTimeFormate 
UNION
ALL #其他报销
SELECT 
  SUM(costsPrice) AS sumCostPrice,
  DATE_FORMAT(createTime, '%Y-%m') AS createTimeFormate 
FROM
  `t_orther_costs` 
WHERE companyId = 39 
  AND createTime >= "2021-01-01" 
  AND createTime <= "2021-12-31" 
GROUP BY createTimeFormate ;

使用 UNION ALL进行拼接；

请注意，UNION 内部的 SELECT 语句必须拥有 相同数量的列 。列也必须拥有相似的数据类型。同时，每条 SELECT 语句中的 列的顺序 必须相同。