[步骤]

2023年的利润数据，zhcxkj_dw_bi.rb_report_ordersettlement 比 zhcxkj_dw_bi.rb_report_ordersettlement 大很多，尤其 8 - 11 月

[结果]

代码：

SELECT a.ShipTime, a.profits_a, b.profits_b, a.profits_a - b.profits_b diff
FROM (
SELECT DATE_FORMAT(ShipTime, '%Y-%m') ShipTime,  sum(profits) profits_a
FROM zhcxkj_dw_bi.rb_report_ordersettlement GROUP BY DATE_FORMAT(ShipTime, '%Y-%m')
) a
LEFT JOIN (
SELECT DATE_FORMAT(ShipTime, '%Y-%m') ShipTime, sum(profits) profits_b 
FROM zhcxkj_bi.t_dwdwd_order_ordersettlement GROUP BY DATE_FORMAT(ShipTime, '%Y-%m')
) b ON a.ShipTime = b.ShipTime
WHERE a.ShipTime >= '2022-12'
ORDER BY ShipTime

[期望]