阅读背景:

SQL:左连接和和和:算术溢出错误将表达式转换为数据类型int

来源:互联网 

I have this query:

我有这个查询:

select p.UserName, sum(b.PercentRials) as amount, sum(r.Amount) as Pays
from bills b inner join UserProfiles p on b.PayerUserName=p.UserName
left outer join PayReceipts r on p.UserName=r.UserName
where p.[Percent]>0 and b.PayDate>'2014-11-20'
group by p.UserName
select p.UserNam



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: