更新时间:2023-02-03 17:32:49
SELECT l.*,
q.summary AS SummaryPreviousYear
FROM lists l
LEFT JOIN
(
SELECT Date,
Summary
FROM lists
WHERE MONTH(Date) = 12
) AS q
ON YEAR(l.Date) = YEAR(q.Date) + 1