表A(Id,UserName,CreateTime) UserName---用户名,CreateTime-注册时间
数据:
Id UserName CreateTime
1 a 2010-05-02
2 b 2010-05-02
3 c 2010-05-02
表B(Id,UserName,bMoney,CreateTime) UserName---用户名,CreateTime-何时消费,bMoney---所花金额
数据:
Id UserName CreateTime bMoney
1 a 2010-05-02 10.00
2 a 2010-05-02 5.00
表C(Id,UserName,cMoney,CreateTime) UserName---用户名,CreateTime-何时充值,cMoney---充值金额
Id UserName CreateTime cMoney
1 b 2010-05-02 2.00
想要的统计结果表D
UserName bMoney cMoney Time
a 10 null 2010-05-03
a 16 null 2010-05-02
b null 2.00 2010-05-02
数据:
Id UserName CreateTime
1 a 2010-05-02
2 b 2010-05-02
3 c 2010-05-02
表B(Id,UserName,bMoney,CreateTime) UserName---用户名,CreateTime-何时消费,bMoney---所花金额
数据:
Id UserName CreateTime bMoney
1 a 2010-05-02 10.00
2 a 2010-05-02 5.00
表C(Id,UserName,cMoney,CreateTime) UserName---用户名,CreateTime-何时充值,cMoney---充值金额
Id UserName CreateTime cMoney
1 b 2010-05-02 2.00
想要的统计结果表D
UserName bMoney cMoney Time
a 10 null 2010-05-03
a 16 null 2010-05-02
b null 2.00 2010-05-02
cMoney C.CreateTime Time
from B
inner join C
on B.UserName = B.UserName and B.CreateTime = C.CreateTime