SELECT a.[UserID],b.[Name],sum (c.[Money]+c.[Bank])as TotalMoney
FROM Table1 a(nolock)
LEFT JOIN Table3 c(nolock) ON a.[UserID]=c.[UserID], Table2 b(nolock)
WHERE a.[UserID] = b.[UserID] and a.[Time] >= '2011-01-01' AND a.[Time] <= '2011-12-31'
GROUP BY a.[UserID],b.[Name]
ORDER BY a.[Time] DESC
FROM Table1 a(nolock)
LEFT JOIN Table3 c(nolock) ON a.[UserID]=c.[UserID], Table2 b(nolock)
WHERE a.[UserID] = b.[UserID] and a.[Time] >= '2011-01-01' AND a.[Time] <= '2011-12-31'
GROUP BY a.[UserID],b.[Name]
ORDER BY a.[Time] DESC
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
