Mysql -基于月份日期合并两个表

SELECT 
    DATE_FORMAT(sale_date, '%Y-%m') AS sale_month,
    SUM(sales_2022.amount) AS total_sales_2022,
    SUM(sales_2023.amount) AS total_sales_2023
FROM 
    sales_2022
LEFT JOIN 
    sales_2023 ON DATE_FORMAT(sales_2022.sale_date, '%Y-%m') = DATE_FORMAT(sales_2023.sale_date, '%Y-%m')
GROUP BY 
    sale_month;

SELECT 
    DATE_FORMAT(sale_date, '%Y-%m') AS sale_month,
    SUM(sales_2022.amount) AS total_sales_2022,
    SUM(sales_2023.amount) AS total_sales_2023
FROM 
    sales_2022
LEFT JOIN 
    sales_2023 ON DATE_FORMAT(sales_2022.sale_date, '%Y-%m') = DATE_FORMAT(sales_2023.sale_date, '%Y-%m')
GROUP BY 
    sale_month

UNION

SELECT 
    DATE_FORMAT(sale_date, '%Y-%m') AS sale_month,
    SUM(sales_2022.amount) AS total_sales_2022,
    SUM(sales_2023.amount) AS total_sales_2023
FROM 
    sales_2023
LEFT JOIN 
    sales_2022 ON DATE_FORMAT(sales_2023.sale_date, '%Y-%m') = DATE_FORMAT(sales_2022.sale_date, '%Y-%m')
WHERE 
    sales_2022.sale_date IS NULL
GROUP BY 
    sale_month;