Mysql 多表合并统计

最新推荐文章于 2024-07-12 14:26:59 发布

weixin_34050389

最新推荐文章于 2024-07-12 14:26:59 发布

阅读量1.1k

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/3556610/blog/1816528

版权

2019独角兽企业重金招聘Python工程师标准>>>

select count(*) ,t.warehouse , DATE_FORMAT(t.shipped_date, '%Y-%m-%d') shipped_date  from  
(	
	select order_no,warehouse,shipped_date,rowstate from customer_order_tab 
	union all 
	select order_no,warehouse,shipped_date,rowstate from customer_order_arc_tab 
) t
where t.rowstate in ('Delivered','Returned') 
group by  t.warehouse,DATE_FORMAT(t.shipped_date, '%Y-%m-%d')
order by t.shipped_date asc

转载于:https://my.oschina.net/u/3556610/blog/1816528