34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT a.* ,
ISNULL(B.[money], 0) AS [money]
FROM A
CROSS APPLY ( SELECT SUM([money]) AS [money]
FROM B
WHERE userid = a.userid
) AS B;
SELECT a.* ,
ISNULL(B.[money], 0) AS [money]
FROM A
LEFT JOIN ( SELECT userid ,
SUM([money]) AS [money]
FROM B
GROUP BY userid
) AS B ON a.userid = B.userid;