34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT id,
Nubmer,
ISNULL(ipcount, 0) AS ipcount
FROM dbo.a
LEFT JOIN
(
SELECT Nubmer,
COUNT(DISTINCT IP) AS ipcount
FROM dbo.b
WHERE DATEDIFF(dd, CreateTime, GETDATE()) = 0
GROUP BY Nubmer
) t
ON a.Number = t.Number;