SELECT c.卡号, c.早餐总数, c.午餐总数, b.姓名, b.序号 from b,
(select a.卡号, SUM(a.早餐) AS 早餐总数, SUM(a.午餐) AS 午餐总数 from a WHERE MONTH(a.日期) = MONTH(GETDATE() GROUP BY a.卡号)
) c where c.卡号 = b.卡号 and
(select a.卡号, SUM(a.早餐) AS 早餐总数, SUM(a.午餐) AS 午餐总数 from a WHERE MONTH(a.日期) = MONTH(GETDATE() GROUP BY a.卡号)
) c where c.卡号 = b.卡号 and
(select a.卡号, SUM(a.早餐) AS 早餐总数, SUM(a.午餐) AS 午餐总数 from a WHERE MONTH(a.日期) = MONTH(GETDATE() GROUP BY a.卡号)
) c where c.卡号 = b.卡号
MONTH(a.日期) = MONTH(GETDATE() GROUP BY a.卡号
AS 午餐总数, b.姓名, b.序号
FROM a INNER JOIN
b ON a.卡号 = b.卡号
WHERE (MONTH(a.日期) = MONTH(GETDATE()))
GROUP BY a.卡号,b.姓名, b.序号