表User(UserID,UserName)
1 , User1
4, Userdf
5, Userdd
8, Userasdf
....表UserLog(UserID,Money)要求,
读出表User中的每一天记录,然后根据这个UserID,去UserLog表中统计Money的总和for(User表中的记录1 到记录 N)
得到UserID, select Sum(money) from UserLog where userID = UserID不晓得怎么写
1 , User1
4, Userdf
5, Userdd
8, Userasdf
....表UserLog(UserID,Money)要求,
读出表User中的每一天记录,然后根据这个UserID,去UserLog表中统计Money的总和for(User表中的记录1 到记录 N)
得到UserID, select Sum(money) from UserLog where userID = UserID不晓得怎么写
from user
select user.userId, Sum(money) as total from user left join UserLog on user.userId=UserLog.userId group by user.userId
select u.UserID, sum(l.Money) as Total
from User u left join UserLog l on u.UserID=l.UserID
group by u.UserID
FROM dbo.UserLog AS A
LEFT JOIN dbo.User AS B ON A.UserID = B.UserID
GROUP BY A.UserID经测试,,
select a.UserID, sum(b.Money) as SumMoney from User a left join UserLog b on a.UserID=b.UserIDgroup by a.UserID
我希望的是:
每次读User表的一个记录,取出UserID,再去UserLog表中进行统计。
这种组合的查找不行,数据量太多了
没有清晰的思路 很容易误入歧途简单罗列出自己的需求
学会把复杂的需求分解正多个简单的需求
还有 你说每天 你日期字段 在什么日志中吗?