哪位帮我看看!!!
SELECT Smart_Card.PersonnelID, Smart_Personnel.Name, Smart_SF_Deal.CardSerial, COUNT(Smart_SF_Deal.CardSerial) As ConsumerCount
FROM Smart_Personnel INNER JOIN Smart_Card ON Smart_Personnel.PersonnelID = Smart_Card.PersonnelID
RIGHT OUTER JOIN Smart_SF_Deal ON Smart_Card.CardNo = Smart_SF_Deal.CardNo
WHERE (Smart_SF_Deal.CardSerial IS NOT NULL) AND ({ fn YEAR(Smart_SF_Deal.DateTime) } = '2002')
AND ({ fn MONTH(Smart_SF_Deal.DateTime) } = '8')
GROUP BY Smart_SF_Deal.CardSerial, Smart_Personnel.Name, Smart_Card.PersonnelID