我有一个要求,我们的系统必须列出所有成员已经张贴优惠券和所有用户没有张贴优惠券。我制作了一个SQL脚本来提取已经发布优惠券的成员列表。以下是代码:
SELECT DISTINCT
b.Email,
b.FirstName,
b.LastName,
b.MemberDisplayName AS DisplayName,
b.MemberID
FROM ClassAd a
INNER JOIN Member b ON b.MemberID = a.MemberID
WHERE a.PostType = 'CPN'
AND DATEDIFF(d, 0, GETDATE()) <