验证去年日期是否正确-- 测试传入 2025-01-01 → 返回去年同日 20240101 SELECT DATE_FORMAT(DATE_SUB(STR_TO_DATE(20250101, %Y%m%d), INTERVAL 1 YEAR), %Y%m%d) AS last_year_date;列子SELECT today.tjrq, today.dwmc, today.brye / 10000 AS brye, today.brxz, -- 今日余额 - 去年同日余额 同比 (today.current_balance - yesterday.current_balance) AS tongbi, today.brye / 82 / 10000 AS brdj, today.byxz, today.bjxz, today.bjxztbzl, today.bnxz, today.bnxztbzl, today.bnzf, today.bnzfmc FROM -- 今日数据 (SELECT ttt.*, brxz AS current_balance FROM ydyy_ye_pq ttt WHERE ttt.tjrq DATE_FORMAT(${p_riqi}, %Y%m%d) AND ttt.dwmc 北京市) AS today -- 关联去年同日数据固定关联1条数据 JOIN -- 去年同日数据 (SELECT brxz AS current_balance FROM ydyy_ye_pq WHERE dwmc 北京市 -- 核心获取去年同一天的8位日期 AND tjrq DATE_FORMAT(DATE_SUB(STR_TO_DATE(DATE_FORMAT(${p_riqi},%Y%m%d), %Y%m%d), INTERVAL 1 YEAR), %Y%m%d)) AS yesterday -- 关联条件两个子查询都只有1条数据固定关联 ON 11;